turning OFF track changes, undo and trace precedents/dependents

D

david34

Hello,

Is it possible to turn OFF change-tracking, undo and the trace
precedents/dependents features in order to improve calculation times and the
performance of a very large file in Excel 2007?

Thanks!
 
D

david34

Dear Charles,

Thanks very much for your helpful response. I also read the 'Improving
Performance in Excel 2007' document you referenced and found it to be very
helpful as well.

I think one of the problems with my spreadsheet is that I need to minimize
the Used Range. When I tried to delete the unnecessary rows I get an
'insufficient memory' error message. Is there another way to minimize the
Used Range rather than deleting rows/columns?

Thanks!
Derek
 
C

Charles Williams

Hi Derek,

Deleting is the way to go: try doing it in smaller chunks.

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com
 
D

david34

Dear Charles,

Thanks again for the helpful response. I'm currently having a problem with
saving my spreadsheet but hopefully it will finish saving soon and I can try
some of the strategies you suggested to get it working better. In case I'm
still not able to figure out what's slowing down the spreadsheet, would it be
possible to send it to you to see if someone at your firm can get it working
better? I've worked on it quite a bit already so I'm not optimistic that I'll
be able to get it operating more efficiently. Could you give me a general
idea what you would charge for this (if this is the kind of work you would
accept)? I'm way behind in meeting a deadline and really need to get the
spreadsheet working faster soon...

Thanks again,
Derek
 
C

Charles Williams

We would be happy to help speed it up. I will reply in more detail offline.

regards
Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com
 

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

Similar Threads

Trace Dependents doesn't work (precedents does!) 4
Excel needs a better interface to trace precedents and dependents 1
Trace Precedents /dependents in another sheet 5
Trace Precedents and Dependents Arrows are Invisible 2
track changes 0
Trace Dependents and Precedents not working 0
Excel XP: Showing Trace Precedents Arrows for Multiple Cells... 4
Track and trace 9

Top