Excel used to start on the home page and mow starts with a blank sheet

ScooterNorm

New Member
Joined
Feb 25, 2024
Messages
28
Office Version
  1. 2016
Platform
  1. Windows
My excel (version Microsoft® Excel® LTSC MSO (16.0.14332.21007) 64-bit ) used to start on the Home page and now it starts up on a new worksheet.
How can I make open on the Home page like it used to?
Thanks,
 
File - Options - General then scroll down to the very last option and put a check in the box (mine isn't checked)

1743236349264.png
 
Upvote 0
Thanks for your response.
On my version both check boxes at the bottom where checked.
I uncheck "Show the Screen.." saved and restarted, still opened with a blank worksheet.
Then I checked the "Show the Screen.." saved and restarted, still opened with a blank worksheet.
It seems that had no effect on this issue.
 
Upvote 0
Also check in File -> Options -> Advanced -> General -> to see if there is anything in 'At startup, open all files in:'

1743289592342.png


Also, in the vba window in the Immediate window type the following and press Enter
?Application.StartupPath
Check for anything in the folder reported from this
 
Last edited:
Upvote 0
Also check in File -> Options -> Advanced -> General -> to see if there is anything in 'At startup, open all files in:'

View attachment 123826

Also, in the vba window in the Immediate window type the following and press Enter
?Application.StartupPath
Check for anything in the folder reported from this
Thanks for your response.

There is nothing in File -> Options -> Advanced -> General -> 'At startup, open all files in:'
 
Upvote 0
Also check in File -> Options -> Advanced -> General -> to see if there is anything in 'At startup, open all files in:'

View attachment 123826

Also, in the vba window in the Immediate window type the following and press Enter
?Application.StartupPath
Check for anything in the folder reported from this
In addition when I execute ?Application.StartupPath in the vba window in the Immediate window it says:
C:\Users\Norm\AppData\Roaming\Microsoft\Excel\XLSTART
The only thing in the folder is the PERSONAL.XLSB file.
And just to see if it was the issue, I removed it and reopened Excel and I got the same result.

Also, BTW each time I start Excel, the name of the Sheet1 file is incremented.
It's currently at Book25.xlsx and when I close excel and reopen it, the file is Book26.xlsx.....
 
Upvote 0
My excel (version Microsoft® Excel® LTSC MSO (16.0.14332.21007) 64-bit ) used to start on the Home page and now it starts up on a new worksheet.
How can I make open on the Home page like it used to?
Thanks,
Before trying a repair or a re-install, I thought I would just reboot my PC.
And silly me, that fixed the problem.
Thanks to everyone for your help, I really should have thought to reboot first.
Lesson learned (again Haha).
 
Upvote 0
Solution
Also, BTW each time I start Excel, the name of the Sheet1 file is incremented.

That gives me the impression that Excel never shut down correctly, if it happens again with Excel closed have a look in Task Manager and check if Excel is still showing.

Happy you have it working again
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top