Excel workbook

  • Thread starter Thread starter sPhillip
  • Start date Start date
S

sPhillip

I have 110MB excel workbook(single). Do I need faster CPU
or more memory to speed up the processing when I made any
changes.

Thank you
 
Hi sPhillip!

That size must be some kind of record. My recommendation would be to
invest in ways of making that workbook smaller.

Three top tips for me would be:

1. Get used range to be efficient:

Use:
Debra Dalgleish:
http://contextures.com/xlfaqApp.html#Unused

2. Replace any "use once only" formulas by their values using:

copy > edit > paste special > values OK

3. Check whether it's possible to have some material in other
workbooks.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top