Windows 10: Excel Worksheet in Drive G

I did something to make a worksheet that I had prepared in Excel to go to my external drive G. Now each time I need to get the worksheet for some reason it tells me that it is not there, but I can see it in the external drive. I want to it on drive C.
Suggestions?

:)

 

Not all opened excel worksheets in the grouping icon are showing up on the task bar

I've got 3 excel worksheets open (excel 2010 window 10), while I click on the icon on the task bar, where all worksheet windows group into, I can only see 2 work sheets and the 3rd worksheet is not showing up.

I can navigate to the "disappeared" worksheet by using Alt+Tab, but it is quite annoying. Does anyone else have the same problem? Does anyone know how to get this fixed?

Much appreciated.

 

Alt-Tab in Windows 10

Now, Copy - Paste from one worksheet cell to another worksheet cell does not work at all. The normal options for Paste are not available. It wants to copy it as an Excel Worksheet 3 object.

 

Why not copy & paste or move the worksheet from the G: drive to the C: drive if that's what you want. What's stopping you?

 

If you saved the worksheet on C drive in Excel, that's where it will look for it. If you moved it to drive G (even by accident), Excel is still looking for it at the last known location where you saved it. If you open Excel and navigate to the location on the G drive where you know it is, then open it, and "save as" to the original location on the C drive, Excel will know where it is, and you will be able to open it next time from within the Excel program.

 

If Drive G was the drive assignment by the OS, you can be seeing a ghost that happens with Windows 10, when the OS does not properly let go of the device.

We call this a Phantom Drive, when the UUID is still assigned to a drive letter. Most people find this happens with Fast Startup. See if the following works for you. Just remember to replace the Phantom Drive letter in the command shown. "The command to remove a drive letter - which shouldn't be needed, but hey, Win10, there are still some bugs - is mountvol <drive> /D, so for you it would be mountvol S: /D and mountvol T: /D. You can also try mountvol /R, which should remove all drive letter assignments for which there is no currently mounted drive. You can also try using /P in place of /D, but it's intended to be used while the volume is actually present.

You can also use the remove command in diskpart to remove drive letter assignments. You mentioned using mountvol to try re-assigning the drive letters but didn't mention trying to remove them. I'm pretty sure it just calls the same APIs as mountvol, actually.


All of these commands will need to be run as Administrator, naturally."