Excel File - using too much memory
#1
Scooby Regular
Thread Starter
Join Date: Oct 2002
Location: ex UK [SE], now Sunshine State [QLD,AUS]
Posts: 565
Likes: 0
Received 1 Like
on
1 Post
Excel File - using too much memory
We have an excel file that is using 4,719 kb.
It contains big data, but just a few formulas.
Basically, 16,700 rows of data, and 3 or 4 columns of simple formulas.
The file is too large to do a data sort.
We use terminal services so maybe that is part of the problem.
I want to reduce file size, but retain all the data.
Where is big memory used.....??
Formulas
Fonts
Formats
Colours
I thought it was in formulas, but deleting superflous formulas (in an ad hoc way), plus simplyfying colours now means a file size of 8,800 kb. HELP !!
It contains big data, but just a few formulas.
Basically, 16,700 rows of data, and 3 or 4 columns of simple formulas.
The file is too large to do a data sort.
We use terminal services so maybe that is part of the problem.
I want to reduce file size, but retain all the data.
Where is big memory used.....??
Formulas
Fonts
Formats
Colours
I thought it was in formulas, but deleting superflous formulas (in an ad hoc way), plus simplyfying colours now means a file size of 8,800 kb. HELP !!
Last edited by velohead66; 09 September 2004 at 07:44 AM. Reason: spellings
#2
Scooby Regular
Join Date: Oct 2003
Location: Cheshire
Posts: 671
Likes: 0
Received 0 Likes
on
0 Posts
if the file has got bigger when you have removed data, make sure track changes is turned off.
Im sure there is some sort of Formula auditing (history) kept somewhere too that could be turned off.
Mark
Im sure there is some sort of Formula auditing (history) kept somewhere too that could be turned off.
Mark
#3
After you've turned off tracking changes etc...
Try copying all of the cells of the existing file and pasting them into a new Excel spreadsheet, then save the new file with a different name. Compare the 2 file sizes and the new one may well be much smaller.
Try copying all of the cells of the existing file and pasting them into a new Excel spreadsheet, then save the new file with a different name. Compare the 2 file sizes and the new one may well be much smaller.
#4
Scooby Regular
Join Date: Oct 2000
Location: same time, different place
Posts: 11,313
Likes: 0
Received 4 Likes
on
2 Posts
I had a similar problem six months ago.
http://bbs.scoobynet.co.uk/showthread.php?t=289304
I think Mick's suggestion worked for me.
http://bbs.scoobynet.co.uk/showthread.php?t=289304
I think Mick's suggestion worked for me.
#5
Scooby Regular
Join Date: Jun 2003
Location: a very nice man :-) with one Fairy Token
Posts: 2,203
Likes: 0
Received 0 Likes
on
0 Posts
As per the final comment on the linked thread above, try using Access. Spreadsheets are not really suited (IMHO) to that sort of amount of data and Access is far more efficient.
#6
Originally Posted by velohead66
We have an excel file that is using 4,719 kb.
It contains big data, but just a few formulas.
Basically, 16,700 rows of data, and 3 or 4 columns of simple formulas.
The file is too large to do a data sort.
We use terminal services so maybe that is part of the problem.
I want to reduce file size, but retain all the data.
Where is big memory used.....??
Formulas
Fonts
Formats
Colours
I thought it was in formulas, but deleting superflous formulas (in an ad hoc way), plus simplyfying colours now means a file size of 8,800 kb. HELP !!
It contains big data, but just a few formulas.
Basically, 16,700 rows of data, and 3 or 4 columns of simple formulas.
The file is too large to do a data sort.
We use terminal services so maybe that is part of the problem.
I want to reduce file size, but retain all the data.
Where is big memory used.....??
Formulas
Fonts
Formats
Colours
I thought it was in formulas, but deleting superflous formulas (in an ad hoc way), plus simplyfying colours now means a file size of 8,800 kb. HELP !!
Edited to say that's what earlier post (via link) suggested - [Slap]
Last edited by Beer Good; 11 September 2004 at 01:19 AM.
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM