Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update links & calculations upon command
Hi.
I have a workbook that is rather large. It contains a link and a list of calculations. Instead of having to wait 2-3 minutes for this workbook to open ( update link and perform the calculations), I'd rather link this action to a button to be excecuted only after the data is changed. Any suggestions on a code to perform all calculations and links upon command and then turn them both off? thanx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update links & calculations upon command
You don't need any VBA to accomplish your goal:
1. Open Excel (not the file) and set the calculation mode to manual 2. From Excel (not double-clicking an icon) open the file the file will open in manual mode 3. Tell the Wizard not to update links 4. Do your editting When you are ready to refresh & recalculate: 5. Set the calculation mode to automatic 6. Edit Replace replacewhat = replacewith = Replacing equal signs with equal signs will force the re-evaluation of all the equations in the sheet. All links will get updatted and values re-calculated. -- Gary''s Student - gsnu200766 "J.W. Aldridge" wrote: Hi. I have a workbook that is rather large. It contains a link and a list of calculations. Instead of having to wait 2-3 minutes for this workbook to open ( update link and perform the calculations), I'd rather link this action to a button to be excecuted only after the data is changed. Any suggestions on a code to perform all calculations and links upon command and then turn them both off? thanx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Suppress Update Links dialog AND don't update links | Excel Programming | |||
Excel 2003 - Update or Don't Update Links Problem | Excel Programming | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |