Excel cell duplication

Question

Hi, we have a simple spreadsheet set up across many sheets (one for each month of year). Sometimes we enter data into a cell on one sheet and later on we realise that it has somehow copied onto the corresponding cell on all the other sheets. I have looked online to see if this is an issue but all I can find are suggestions how to do this, but not how to stop it. I have looked at 'Queries and Connections' along with 'Grouping', but nothing there. Any help would be appreciated as it has happened on a couple of similar spreadsheets that are all on our business Sharepoint.

Answer 1

I suspect that you accidentally selected multiple sheets (by Ctrl-click on sheet tabs) and then enter data into one of them. All other sheets will then get the same entry in the same cell.

More about that in the link below.

https://support.microsoft.com/en-us/office/select-worksheets-096b40c9-0ee7-4980-bac6-cc92aec7b266

Answer 2

have looked online to see if this is an issue but all I can find are suggestions how to do this,

online？

how about read only authorization？

Answer 3

That I don't know, sorry!

Answer 4

I suspect that you accidentally selected multiple sheets (by Ctrl-click on sheet tabs) and then enter data into one of them. All other sheets will then get the same entry in the same cell.

More about that in the link below.

https://support.microsoft.com/en-us/office/select-worksheets-096b40c9-0ee7-4980-bac6-cc92aec7b266

Thanks for the reply. Although we do occasionally select all sheets to search data and can see how this is done, but we have been in a spreadsheet when this has happened with no multiple sheets selected.

If this has happened due to multiple sheets being selected, how can we prevent this on Sharepoint as we have many users not in the same office so it is not just a case of shouting across to a colleague not to enter any data until I have de-selected all sheets?