Windows 10: Documents vanished in Google Sheets

There are documents vanished in my Google Sheets.I am the only owner.I did not do any removals.They are not in my bin My bin is programmed to keep items still for another 30 days before removing permanentlyWhat I did, was removing big files in my Gmail for creating more space. Can it be connected to this action ? If so, where can I retrace them ?Thank you.

:)

 

P)rinting of Google sheets

how do a print a partial document in google sheets

 

Better overview of different sheets in Microsoft Excel

I would like to suggest you a simple method to create Hyperlink of Sheet Name for easy navigation.





How it works:

• Press Ctrl+K to open the Insert Hyperlink dialog box.
  
• Click the Place in This Document button.
  
• Then link to the sheet, select Sheet name from Cell Reference & press OK.
  
• In Type the Cell reference write the Cell address which you want to
  attach with Sheet's Hyperlink.
  

Note,

• Repeat Step 1 to 3 for other Sheets.
  
• Using this method you can create Sheet's Name list in desire order.
  

 

Excel 2010 Document Inspector reports hidden sheets, not shown in VBA

Here's the list of Objects shown in the VB Project.





So I then ran your List Sheets VB and it led me to what appears to be the issue.

Your List Sheets Sub created a new sheet and listed all the sheets, including the new one and the VB Procedures and Functions. That set me wondering.

So, working on a copy of the XLS, I ran Document Inspector (DI), Hidden Worksheets only, and let it delete those hidden worksheets. And, as I'd wondered, my macros and functions didn't work, they weren't there, DI had deleted them.

So what appears to be the case is that for this workbook at least, DI sees the VB Procedures and Functions items shown in the VB Object List as hidden worksheets, and so deletes them.

I've run DI on other macro-enable spreadsheets but they just have Module 1 containing the macros and are not seen by DI as hidden sheets.

All rather interesting.