Hi all,
I've got 3 spreadsheets open and was working on a side by side with 2 of the spreadsheets.
One of the spreadsheets is a 'template' (actually it's the last quarter's VAT) and it has all the formatting I need to import into Sage as a CSV once I've completed filling it in and saving it out as a CSV.
I've been merrily right-clicking and selecting Hide all morning (and yesterday) and it's right there in the context menu. Problem is, now it's just vanished.
I'm not that familiar with ribbons so I find Hide under View > Window > Hide, I click it and one of the spreadsheets simply vanishes. It's in One Drive but when I click it, it will not open.
As I am working through the bank transactions, I am using Find and then marking with a Fill to show I've entered it so I really need to find this file else it's back to Square One.
EDIT
Can One Drive disconnect or go down? I am cautious of these cloud based auto-saves. The spreadsheet is not in document recovery.
I have just closed Excel down and it asked me if I wanted to save the spreadsheet that's missing so it was floating around somewhere. I saved it but no luck.
It says it was saved to Documents 3 minutes ago. I clicked on the cloud icon on bottom right of Windows 10 and found it in Documents, Excel opens but just as a grey background. Is it possible to hide a spreadsheet from view somehow in Excel? I fear this is what may have happened and I have no idea how to retrieve it or unhide it.
I've got 3 spreadsheets open and was working on a side by side with 2 of the spreadsheets.
One of the spreadsheets is a 'template' (actually it's the last quarter's VAT) and it has all the formatting I need to import into Sage as a CSV once I've completed filling it in and saving it out as a CSV.
I've been merrily right-clicking and selecting Hide all morning (and yesterday) and it's right there in the context menu. Problem is, now it's just vanished.
I'm not that familiar with ribbons so I find Hide under View > Window > Hide, I click it and one of the spreadsheets simply vanishes. It's in One Drive but when I click it, it will not open.
As I am working through the bank transactions, I am using Find and then marking with a Fill to show I've entered it so I really need to find this file else it's back to Square One.
EDIT
Can One Drive disconnect or go down? I am cautious of these cloud based auto-saves. The spreadsheet is not in document recovery.
I have just closed Excel down and it asked me if I wanted to save the spreadsheet that's missing so it was floating around somewhere. I saved it but no luck.
It says it was saved to Documents 3 minutes ago. I clicked on the cloud icon on bottom right of Windows 10 and found it in Documents, Excel opens but just as a grey background. Is it possible to hide a spreadsheet from view somehow in Excel? I fear this is what may have happened and I have no idea how to retrieve it or unhide it.
Last edited: