Software

Ask something
Discussion Locked

Office XP-Excel2002 W/SP2

0 helpful
1 reply

by techv 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I got system with P3-50Mhz/320MB System Memory,Un-nstalled the Office97 and had configure Office XP with Both Service Packs,Now When I am accessing one of several Excel files,which were created/copied in Office97,those files on opening up start processing of their own by indicating in status bar as "calculating cells : 0%" and taking very long time to process,i think approx few hours to calculate and freezing the system for other apps.,hence wanted to know if any one can tell me some alternative to skip this.

Thanks

1 reply

by thamer

Since the default calculation for Microsoft Excel is automatic... try this..

-Open Excel and under the Tools menu, select option.
- Select the Calculation tab and set it to "Manual" then hit the OK button.

Now open one of the Excel's 97 files and (Hopefully!) the Calculate function will not run. Only when you click Calc Now on the Calculation tab it will do that.

Note: When you click Manual, Microsoft Excel automatically selects the Recalculate before save check box. If saving a workbook takes a long time, clearing Recalculate before save may improve the save time.

The Calculate function calculates the active worksheet and any charts and chart sheets linked to it, click Calc Sheet. Selecting other calculation options affectsall open worksheets in the current session.

I hope this helps.

This discussion is closed to new replies.