Hi Sage Community!

Old machine, Excel and Office 32 bit. Run report, no issues. New machine, MS 365 64 bit run exact same report and get #value errors in every calculated field. The formula is simple column D minus column C. Suppress zeros also fails. Report executes without errors, except the result is filled with #value errors. Again, same report works in 32 bit. Same result if I "design" or "run" the report.

Is this a subtle setting in Excel that didn't transfer over? A rogue add-in. I was under the impression that Excel 64 bit now works with Financial Reporter.

What am I missing here?

Michael

Details:

New machine: Window11, Office 365 64 bit, Sage 300 ERP 2024 PU3.

Old machine: Windows 10. Office 2016 32 bit, Sage 300 ERP 2024 PU3.