Forum Discussion
How do I open an excel spreedsheet where I want.
- Hi Hans
Thank you for your help and let me apologise for the length of this post. I have solved the problem of my excel worksheet opening at the top and not where I last closed it.
My PC is about 4 weeks old and has Windows11 installed. My previous PC was 10 years old and had Windows 10 installed. My old PC would not support Windows11 and word and excel documents were not working properly, so I used a Microsoft application called Cool Office.
When I check the excel file extension for the documents I was having trouble with I found it was .ods. I went online and found a document converter, then made a copy of one of my excel documents and dragged and dropped it into the converter after I had set it to convert .ods to .xsls and send it back to my PC desktop. I check the file extension of the converted document and sure enough it is .xsls. After several times opening and closing the document it opens at the same place where I last closed it. Many thanks Derek1947
Make sure that you save the workbook before you close it.
Thanks Hans, I tried your suggestion, but I still got the same result.
That is strange. Normally, Excel opens a workbook the way you last saved it.
Do you have VBA code that could cause this? Or an add-in?
Hi Hans
I only bought this PC 3 weeks ago and it came with Windows 11. My previous PC had Windows 10.
I have no idea about VBA codes or add ins.
Try the following:
Quit Excel completely.
Hold down the left Ctrl key while you start Excel again.
It will ask you whether you want to start Excel in Safe Mode. Answer Yes.
Create or open a workbook.
Select for example cell F100, then save the workbook (Ctrl+S) and close it (Ctrl+F4) without quitting Excel.
What do you see when you reopen the workbook from within Excel?