Quit having a spreadsheet reopen in a different size than it was when it was closed
When I close a spreadsheet, it is the size I want it to be. But when I reopen it, Excel is as likely as not to have "decided" that it knows better than I do what I want, and it reopens in a different size. Sorry, but I do know better than Excel does what I want, and resent the arrogance displayed in changing my preferences. Make it stop!!!
When you say that it opens a different size – can you give more info? Do you mean the application window is a different size (it shouldn’t be) or that the font sizes (zoom) are different? (again, they shouldn’t be)
Additionally, if you can post a video of what you’re seeing, that would be a big help for us.
If there is a problem here, it’s definitely something we’d want to fix.
This is sure an annoying "feature" since I work with about 2000 spreadsheets and want them to remember their relative size and position individually. What a nuisance the current method is!!
Why are you asking for more info - this has been a problem in every version of Excel/Office, and has been reported endless times. I've just got Office 2019, and guess what - the problem persists. Sort it out. You charge enough, sort out the problems you've KNOWN ABOUT FOR DECADES.
Excel rather stupidly assumes you want any workbook opened at the size and position of the last one that was closed - regardless of the fact that prior workbook isn't the same workbook you're now opening. I think it's fairly obvious that it should attempt to open a workbook at the position and size it was last closed, individually, and not make the clearly brain-dead solution that the last workbook opened is at the position and size you want ALL workbooks subsequently opened. And of course, this is trivial if designed in. Unfortunately, while this question has been asked a number of times over the years, MS has never seen fit to deal with it, nor offers any rationale for the method they have implemented.Sadly, entirely normal for problems reported to MS (and that's 26 years of being a MS-platform developer speaking).
My problem is that ALL spreadsheets have started opening full screen, no matter what size they were when I saved them. This suddenly started a few days ago, and affects ALL spreadsheets (Excel 2016 for Mac). Incredibly inconvenient!
Dan Battagin (MS Xl) said "If there is a problem here, it’s definitely something we’d want to fix."
That was 2016.
Has any Excel version has been fixed yet ?
Kevin Osborn commented
I can clarify because I feel the pain of the original post. Excel (w/ 2016 I think) now allows different workbooks in separate windows (yea ... thank you). But now if I open 2 workbooks and I move 1 to the left and make it small and I move the other to the right and make it large then I close both workbooks. When I reopen either workbook (or any other workbook for that matter) Excel will open the the workbook to the location and size of the last workbook when Excel exited.
Excel should remember the window size (AND location) of each closed workbook and the next time that specific workbook is opened it should open with the same size and in the same location as the last time it was closed. Not based on the size and location of the last closed workbook in Excel.
Many of us work with multiple workbooks open at the same time and we position them and size them independently so we can better work on them simultaneously. Unfortunately when we close Excel and then open them the next day they all open cascaded in the position of the last closed workbook and with the window size of the last closed workbook.
Keith Sutherland commented
I advocate this for all Office applications.
When I open a document on my PC, I would like it to show up on the screen the same way it did when I closed it on my PC. But if I have opened a different spreadsheet (let's call it B, for clarity), and resized the Excel window for viewing spreadsheet B, then, when I reopen spreadsheet A, the Excel window is sized and positioned as I wanted it for spreadsheet B.
In other words, have the window settings on a device for an Office document be linked to the document, not to the application.
Ed Hansberry commented
Dan, the Excel 2016 app seems to have a mind of its own when it is opened in anything but full screen. I have a Surface Pro 4 (high DPI) attached to an external monitor (low DPI) so that may be contributing to the issue.
As an example, when I open a file on my Mac, it is *always* the same size. The window size doesn't change from session to session - the exception being is if I opened it on my iPhone and when I return to the Macbook, it is a postage stamp size. :-(
But on Windows, Excel seems to make no effort to remember what size the window was. In earlier versions on Windows this was understandable as the files were all part of the same window, but in Excel 2016, each file gets its own window and that size should be remembered.
Ed Hansberry commented
This goes for the Mac too. This is especially problematic when you open the file on a mobile device, like an iPhone.