Excel "moving" data.

Occasional Visitor

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 or two rows, sometimes left or right a column.  They claim this is occurring on a worksheet which has VBA dialogs, but for cells which have no VBA coding associated to them.  Has anyone ever heard of such a thing?  Thank you.

1 Reply

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!




Related Conversations
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Maps Data for Scotland
Chris Nicol in Excel on
19 Replies
Will there be a SPSS export directly from MS Forms?
AzimianV in Microsoft Forms on
1 Replies
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies