MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Workbook Opens on Missing Monitor


May 10, 2017 - by Bill Jelen

Workbook Opens on Missing Monitor

An Excel workbook opens, but you can't see it! The taskbar says the workbook is open, but it is not on the screen. This recently happened to me when I opened a workbook that I last opened three years ago when I had a second monitor.

Watch Video

  • This might happen in Excel 2013 or newer: You open a workbook in Excel.
  • The workbook is not visible. It is in the View, Windows list.
  • But you can not see it.
  • Somehow… the workbook was last saved when I had two monitors.
  • The workbook is remembering its position as somewhere on the second monitor.
  • But I don't have two monitors anymore.
  • Use View, Window to switch to the other workbook
  • Then, hold down the Windows key and press the left or right arrow.
  • Win + Left Arrow will move the application back to the left half of the screen.

Auto-Generated Transcript

  • Learn Excel from MrExcel Podcast Episode
  • 2094 workbook opens but is not visible
  • hey today's question is sent in by him
  • he has happened a couple days ago I open
  • a new workbook file open and the
  • workbook oke open it appear to open fine
  • except I couldn't see it and it wasn't
  • this weird problem where I have a blank
  • workbook down in the status bar down in
  • the status bar the task bar is actually
  • showing me both both workbooks are down
  • there I just simply couldn't see it and
  • if I would go to view and switch windows
  • right there it is but it was never
  • opening up and I finally realized that
  • this workbook had not been open for a
  • couple of years and the last time that I
  • opened this workbook I own two monitors
  • I had to mom dual monitors on this
  • computer and that somehow that other
  • workbook was sitting over on the second
  • monitor that's no longer there alright
  • and I had used some VBA to get the dot
  • left and dot top of the window back
  • where I can see it but here's a great
  • trick if you have the flying windows key
  • so on your keyboard between the left
  • ctrl and the left alt you might have
  • that the windows key if you hold down
  • the windows key and press the left arrow
  • it'll bring the active window back into
  • view or windows right arrow will move it
  • to the right half the screen screen so
  • either windows left or windows right
  • will bring it back so just a quick
  • little tip today I guess is really not
  • an Excel trick of working it with any
  • apps at all well that was so short don't
  • even either to wrap it up just a Windows
  • key in either left arrow or right arrow
  • to bring a missing app back into view

Download File

Download the sample file here: Podcast2094.xlsm

Title Photo: Tama66 / Pixabay


Bill Jelen is the author of
MrExcel LIVe

A book for people who use Excel 40+ hours per week. Illustrated in full color.