Good afternoon all,
Currently have an issue with an excel Macro file where some users get a #NAME? error for formula cells. But when the same document is sent to myself/others the error is not shown and the data is displayed correctly. The cells are locked so that users are not able to edit the formulas. The file is also saved as a Macro file (due to some of the formulas that are built and the protection put in place). Not sure if that would have something to do with this error popping up.
Below is what the user with the issue sees
name - error image.JPG
Below is what I show when pulling the same spreadsheet.
Name - non error Image.JPG
All of the users are using the same version of Excel. I would attach a sample but I have not been able to replicate this issue, and it would be hard for me to provide a real world example excluding confidential information.
Thank you for your help as always.
Bookmarks