LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Data hidden/lost in Excel 2003 spreadsheet?

I have an odd situation I was hoping some of you excel experts might be able
to help me with. I was sent a spreadsheet (task schedule list) that was
about 25kb (only 40 rows by 8 columns).
After I did some editing (adding 2 new columns and adding some information
to them) and saved the file, I noticed the file size has ballooned up to
2MB!

I went hunting through the file to see if had accidentally pasted a
something huge from my clipboard but could find nothing. I know it is the
column I added as when I delete the entire column and save the file it goes
back to the original 25kb. But when I delete the rows from this column where
I added data (knowingly!) the file size does not change....it remains 2MB.

I manually scrolled down from row 41 to 65,536 and could see nothing but
white cells. I figure there's some data hidden in there but I can't seem to
figure out how to find it. Can anyone recommend a good way to hunt this
down? Much appreciated.


 
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
Excel 2003 "file error: data may have been lost" after applying SP3 [email protected] Excel Discussion (Misc queries) 2 November 28th 07 10:02 PM
Lost view of spreadsheet EXCEL 2007 Anna Excel Discussion (Misc queries) 0 November 17th 07 10:01 AM
Transferring data to excel spreadsheet 2003 Maurice Excel Discussion (Misc queries) 1 March 10th 07 04:15 AM
Several charts in Works spreadsheet into Excel seem lost. Mike1942 Charts and Charting in Excel 0 January 13th 07 07:41 PM
sort column data with hidden columns - excel 2003 nanimadrina Excel Discussion (Misc queries) 2 April 26th 05 08:27 PM


All times are GMT +1. The time now is 12:22 AM.

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"