Excel workbook

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
 
N

Norman Harker

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top