Unlocking a worksheet locked in Excel 5 with Excel 2000

[mpopnoe]

When trying to unprotect a worksheet locked in Excel 5 with Excel 2000 it fails because the password used is not recognized as the password that locked the file in Excel 5. I assumed the problem is due to the 16 bit Excel 5 vs the 32 bit Excel 2000. At one time I had found a function that was supposed to eliminate that problem but I had no success. Due to our business structure we cannot use Excel 2000 as the application that locks the data (wish we could). End users that have Office 2000 products want to use Excel 2000 so I need to find the fix for this problem. Anyone know the answer?

thanks,
mike

 

[JMANER]

I had my purchaseing manager just copy the contents into a new file. Not a cure but it works. Good luck and may God bless.