Trouble saving 2019 workbook in the hidden view

[Fly_By_Night]

I recently purchased a new Dell tower computer that is running Windows 10. I also purchased and installed Office 2019 Home & Student software. I created a spreadsheet with just a list of business locations on it. (no macros involved) I placed this into a folder that automatically opens this spreadsheet whenever Excel is started. I draw the data off of this sheet from several different workbooks to be used as "Location List" in my drop down boxes. I want this spreadsheet to be hidden from view when it opens so that I only view the open workbook that I am working on not the sheet with the business locations. I go to the View tab on the banner of the business location sheet and select the "Hide" button to hide the whole workbook. I then hit the X close button in the upper right. When prompted if I want to save I select "Yes" The problem is Excel does not remember that the "Hide" button was selected and when the sheet is reopened all the data is visible. (just as if you chose unhide). I moved the spreadsheet outside of my Excel Start up folder to the desktop. Same result. I created another worksheet on the desktop tried to save it in the hidden view but same result. Whenever you open the sheet it is back in the "Unhide Mode" I never had this problem with my old computer and my computer at work. Both run Windows 7 and Office 2013. Not sure what I am missing or if it's a setting but I cannot find anything on the internet. I don't know if it's an Office glitch or a Windows 10 problem. I am open for suggestions.

 

[cyrilbrd]

Add one New Sheet.
Select the tabs you wish to hide
Right click
Select Hide
Save

 

[Fluff]

Hi & welcome to MrExcel.
Whilst I'm using 365 on Win 10 rather than 2019, I cannot replicate that behaviour. If I save a file whilst it's hidden it always opens as hidden, regardless of location or file extension.
Try creating a personal macro file & see if you get the same behaviour with that.

 

[Fly_By_Night]

View attachment 6426
Add one New Sheet.
Select the tabs you wish to hide
Right click
Select Hide
Save

Thank you for your response. This won't work for me. What you are doing is trying to hide an individual worksheet(s). Your cannot hide all worksheets in a workbook. Excel requires that you always leave one sheet visible. I want to hide the entire workbook. Regardless if I put it into a special start up folder or just create a spreadsheet on my desktop when I go to my view tab at the top of the page and select "Hide" then save my changes the sheet when reopened shows all the data is visible. If I hide an individual tab for a worksheet save and close then reopen the sheet remains hidden. In other words I can hide sheets but not the entire workbook.

 

[Fly_By_Night]

Thank you for your response. This won't work for me. What you are doing is trying to hide an individual worksheet(s). Your cannot hide all worksheets in a workbook. Excel requires that you always leave one sheet visible. I want to hide the entire workbook. Regardless if I put it into a special start up folder or just create a spreadsheet on my desktop when I go to my view tab at the top of the page and select "Hide" then save my changes the sheet when reopened shows all the data is visible. If I hide an individual tab for a worksheet save and close then reopen the sheet remains hidden. In other words I can hide sheets but not the entire workbook.

Solution Found
After searching other forum sites and not finding any solutions I decided to uninstall and reinstall Office 2019. Had some problem because my account was messed up on Microsoft's website but with some online assistance I was able to reinstall Office 2019. This fixed the problem! Workbooks are staying hidden when I select the option in the "View" header ribbon and hit save.

 

[Fluff]

Glad you got it sorted & thanks for letting us know