Dual monitor annoyance, but only with Excel

[EdNerd]

(Windows 10 Enterprise and Microsoft 365 apps)
I work on a laptop so I have everything when I go into the field. When I'm in the office, I plug in a second monitor to have more working space. With that, I can open a workbook on the larger second monitor and something else on the laptop. But when I unplug and go into the field, any Excel file (and only Excel, apparently) that was opened on the second monitor remembers that position, and opens off screen. The only way I have found to retrieve it is to temporarily adjust my laptop screen resolution so I can see the file, then drag it over to work with it. But if I close and reopen, it goes right back to off the screen.

Is there a way to reset the stored window position of an Excel file? Or make my laptop forget the second monitor?

Ed

 

[6StringJazzer]

Does this happen with any other applications, or just Excel? Sounds like a video card issue to me. When you unplug the second monitor then go to Windows video configuration (Settings, System, Display) does it still show two monitors? You may have to reset when you go back and forth.

I have used a laptop with second monitor and never experienced so otherwise I'm not sure how to fix it.

 

[EdNerd]

Hi, Jeff. Former bass player here ....

It's just Excel that acts like this. My control panel shows only one monitor.
Maybe a global macro that shows the window position of any open workbook and allows me to change it??

 

[EdNerd]

I found macro code at

Unable to position and resize an Excel Window With VBA

Please consider this code. I am looking for a solution to resolve the "Unable to set the Top property of the Window class" error I get with theline in red. Public Sub ReadingView() 'Stop With Application With ActiveWorkbook ' store current ActiveWorkbook settings View.drawingobjects =...

www.mrexcel.com

that allows me to resize and reposition the workbook ActiveWindow . I'd rather figure out what's happening, but I'll take this in the meantime.

Ed