#1   Report Post  
Silver
 
Posts: n/a
Default 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
  #2   Report Post  
Matt Lunn
 
Posts: n/a
Default

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

  #3   Report Post  
Chip Pearson
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting excel to text file Exceluser Excel Discussion (Misc queries) 1 July 1st 05 03:04 AM
Exporting excel to text file Exceluser Excel Discussion (Misc queries) 1 June 22nd 05 11:26 PM
Empty Workseek: File still too large (>300k) Anik Excel Discussion (Misc queries) 2 March 16th 05 06:21 PM
In Bar Chart, can we display both figures and their respective %a. Airtel Excel Discussion (Misc queries) 3 March 9th 05 02:35 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM


All times are GMT +1. The time now is 03:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"