ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Empty File (https://www.excelbanter.com/excel-discussion-misc-queries/34970-empty-file.html)

Silver

Empty File
 
I saved and closed an Excel file. The next time I opened it, it was empty,
but shows a file size of 14.5 KB. Any suggestions where the contents went
(are)?

Silver

Matt Lunn

Hi,

I think empty workbooks will be about that size anyway. Try pressing Ctrl +
End on each worksheet. This will take you to the last column & last row
containing any data.

Hope this helps,
Matt

"Silver" wrote:

I saved and closed an Excel file. The next time I opened it, it was empty,
but shows a file size of 14.5 KB. Any suggestions where the contents went
(are)?

Silver


Chip Pearson

That's about the typical size for an empty Excel file. Even
though the workbook doesn't contain data in cells, it contains
info about worksheets, various defaults, and other info about the
workbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Silver" wrote in message
...
I saved and closed an Excel file. The next time I opened it, it
was empty,
but shows a file size of 14.5 KB. Any suggestions where the
contents went
(are)?

Silver





All times are GMT +1. The time now is 02:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com