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.
Tony Fisk commented
Still getting the problem with Office 2016. I wonder if there is a "complaint count" limit that has to be reached before Micro$oft actually considers an issue sufficiently annoying that it warrants attention?
This has been going on with Word and Excel for a long time - opens last minimized doc when opening another one. Extremely irritating. Hopefully we won't have to wait until the next version of Office before this "feature" is removed. Otherwise I'd be tempted to move to Open Office or similar, because this really drives me nuts!
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.
This bug drives me crazy. I want a minimized file to stay minimized until I need it.
I agree completely. Instead of moving the newly opened window, I have to move and re-size every window, which is a BIG waste of time when you work with multiple excel files at a time.
Larry Marks commented
Duh. I meant to write "Excel 2016 X64"
Kenneth Barber commented
Not sure why you mentioned PowerPoint.
Larry Marks commented
PowerPoint 2016, x64
When I've set the window of an Excel file to Restore (not Maximize or Minimize, but the size I want by dragging the handles), and save the file, the size isn't saved. The file reopens in Maximize and when the Restore icon is clicked, it goes to an arbitrary size, probably associated with "Cascade."
This goes against Windows practice since Windows 2.0 and 3.0 for DOS (Remember .ini files, anyone?). Why was this change made. I frequently work with two files side-by-side or over-and-under and have to fiddle around to get the state I had when I last used the files.
I can't see any benefit to the new behavior. Why was it changed?
I just left essentially the same comment. Somehow missed this post. There are Excel files that should stay minimized all day, unless something unusual happens that needs to be recorded (consults without appointments for example). It doesn't make sense to open a workbook you need to enter data from web, only to have four other workbooks open up for no reason.
Sometimes I wonder how Bill Gates feels about this kind of garbage happening, and no-one at MS gives a ****. It's not limited to vista either. I had it with XP, and now have it with 7.
Wanna bet this problem will reach a decade without anything being done?
Henrik Stiernstedt commented
Annoying behaviour. Please fix.
The same as in Word. Annoying, counterproductive, very frustrating especially that it has been there for a long time without a fix.
Same thing happens in Word. Drives me crazy!
Exactly as the title states. When I minimize an Excel window, I'm doing it for a reason. It's very annoying to have the minimized window pop back up on my screen when I open another Excel file. If I want it back on my screen, I'll do it myself. At least give us an option to turn this on/off.
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.