MACRO will not work in my new windows 8.1 and Office 2013

[Zebra7860]

Yes, this is the same spreadsheet that has been applied in my Vista laptop and under my desktop with Windows 8.1 and the Vista laptop has no issues with the resulting calculations.

The Vista laptop spits values such as "41.30" "2.870" etc and these values are simply not there in the desktop.

I appreciate all your help

[Rudi]

It would help if you can provide screenshots of the actual formulas producing those #VALUE! errors, as well screenshots of the precedent cells that feed into the formulas. It will assist in determining if the cause of the issue is data entry.

[Zebra7860]

Since this spreadsheet was created for me, how would you suggest that I find the area where the formulas and precedent cells are stored? Again, sorry to sound dense...

[Zebra7860]

Since this spreadsheet was created for me, how would you suggest that I find the area where the formulas and precedent cells are stored? Again, sorry to sound dense...

[HansV]

Would it be possible to attach a copy of the workbook that does not contain sensitive information to a reply?

[Zebra7860]

I will have to ask the developer of the spreadsheet because it is password protected.

[Rudi]

While you are at it, you could inquire from the developer if they have any suggestions to fix the sheet too.

[Zebra7860]

it works now....apparently I saved it as a 'XLSM' spreadsheet and all is well.....THANK YOU for all your help. Much appreciated

[HansV]

Good to hear that!

[Rudi]

Excellent. Glad it is resolved.