LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Large file sizes after modifying spreadsheet in Excel 2007.

I am experiencing problems after modifying spreadsheets in Excel 2007 (saving
as 2003 compatible .xls format). The files were last sucessfully worked on
in Excel 2003, but may have been created using earlier versions.

PROBLEM: Small files become huge, operations become slow and Excel is pretty
much unworkable.

I have read and tried most of the suggestions in earlier posts, which refer
to checking the last used cell and deleting unused rows and columns and site
information in link: http://www.contextures.on.ca/xlfaqApp.html#Unused.

Although, performing the unused cell deletion, does reduce the file size
marginally (from 6,132KB to 4,432KB), it doesn't solve the problem.

However, if I 'Copy & Paste' the used cell contents and formatting into a
new workbook, this works. File size is reduced to a tiny 146KB.

Does any one have know what could be causing this apparent file corruption,
and a possible fix?


 
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
Modifying large CSV files Mike Excel Discussion (Misc queries) 9 March 9th 07 12:15 AM
Problems with my links to an excel 2007 file from a word 2007 file sc Links and Linking in Excel 0 February 21st 07 10:12 AM
Chart sizes with window in Excel 2007? Mosheo Charts and Charting in Excel 2 January 9th 07 02:46 AM
Trouble opening large size Excel file 155Mb in Excel 2007 pl2c Excel Discussion (Misc queries) 2 July 14th 06 11:45 PM
In excel spreadsheet my comment boxes change sizes randomly why? Scully Excel Worksheet Functions 0 November 11th 05 08:46 PM


All times are GMT +1. The time now is 06:42 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"