Excel 2003; Speeding up; 3MB

[network_engineer]

Hi all,

Thanks for all your help in the past week. My excel is nearly completed; however, even without the data, the size is about 3MB, and I guess it is all the formulae.

Question: Whenever I enter data, it starts to re-calculate the whole thing, is there any way that it would ONLY do the calculations later? E.g. design a click-button or something which when pressed would update the data?

Could somebody please help me with this?

Thanks a lot.

Kind regards,
Ben

 

[JD_GFI]

You can turn automatic calculation off by changing the "Calculation Options" under the "Formulas" menu to "Manual". This then requires you to manually chose to calculate formulas using the buttons on the same menu or via the "Calculate" button in the bottom left corner of the window.

Is that what you mean?

 

[AlphaFrog]

If you set the calculation mode to manual as JD_GFI described, the F9 key on the keyboard will also initiate a recalculate.

You can set the option for manual calculation under the menu...
Tools\ Options\ Calculation tab

 

[network_engineer]

Hi all,

Thanks; I am also going to be handing this spreadsheet out to some really basic people: Is there any way somebody would help me create a button e.g. "Update" that the data entry operator could press?

If somebody would kindly guide me, that would be the best! Would really appreciate it.

PS: Is it so that the auto-calculation disabling is made to the workbook? Or is it to the local excel on system? If it is local, is there some way to disable it for the workbook? Reason is that it does re-calculating every time and then it becomes a problem for the operator to wait 30 seconds every time a value is changed.

Kind regards,
Ben

 

[AlphaFrog]

There are several caveats on automatic vs. manual calculation modes. I think this explains it well.

Controlling Excel Calculation

 

[JD_GFI]

If you create a button on the page and insert the following code as the macro to be run on button press it should recalculate the sheet:

Sub Button1_Click()

Calculate

End Sub

 

[network_engineer]

Thanks, I'll check those out.

Would somebody also know the answer to my question?

Is it so that the auto-calculation disabling is made to the workbook? Or is it to the local excel on system? If it is local, is there some way to disable it for the workbook?

Kind regards,
Ben

 

[AlphaFrog]

The link explains the answer to your question.

 

[network_engineer]

Hi all,

Embarrassed now; but I have looked all over the menu, and cannot find the option to draw a button. Any ideas please?

Kind regards,
Ben