Issue where formulas that reference other tabs are being erased randomly

Occasional Visitor

I have a user with an issue where his formulas in a workbook that reference cells in other tabs within the same workbook are disappearing. The formulas that do not reference other tabs are unaffected by this. Has anybody experienced this issue before? He is not using any macros, he seems to have a sufficient amount of RAM (16gb), his office version if 64bit. I am unable to recreate this issue which makes this difficult to troubleshoot. This is happening on xlookups, vlookups, sums, etc (not 1 specific function)

 

Any help would be appreciated, thank you.

0 Replies