Hi there, Thanks in advance for any help provided.
I'm sure there is a simple solution to this simple problem but google has turned up nothing as far as i'm aware.
We are broadcasting a spreadsheet on a large tv screen in the office and are using Microsoft sharepoint and office online to enable people to edit this spreadsheet from their computers. The changes are then reflected on the screen
Just one small problem - Before they click save, the user has to select cell A1 so that, when loaded, the spreadsheet opens and fits the screen.
If they dont select cell A1, the main spreadsheet refreshes (reloads the saved file) and jumps to the last active cell when saved which causes the some parts of the workbook to go off screen.
Is there a way to have excel always save pointing to a specific cell or am I going to have to keep slapping my co-workers over the head if they forget to click A1 before saving.
Many thanks, I look forward to learning a way around this if possible