Forum Discussion

TBill1965's avatar
TBill1965
Copper Contributor
Nov 29, 2018

Excel "moving" data.

I have a user who claims they enter data to a certain cell within a worksheet, save the worksheet, then come back later to find the data in a different cell.  They claim the data moves up or down one...
Excel on Mac
Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Nov 29, 2018

Hi TBill1965

 

Sounds strange to me, even for a MAC!

 

I haven't encountered that before. The only thought I have is that if there's VBA involved, is someone playing with the code and has made some programming errors that is causing the issue? Might be worth a glance at the VBA code to see if there is something going on.

 

The other thought I have is to try and confirm if the user is telling you the truth about this (users don't always describe or understand things correctly) by doing the actions the user has indicated to see if the outcome is what they say it is.

 

I supposed one final thought is to check SharePoint/OneDrive (if the file is being stored there) and see the previous version history and whether the versions show the issue too.

 

Anyway just my thoughts.

 

Best wishes and good luck!

 

Cheers

Damien 

Resources