Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How To Update Formulas Without Refreshing Links Each Time
I have a workbook with links to a live data base. At times I need to change
the way the workbook manipulates the data and then update all formulas but do not want to wait several minutes while the links refresh. If I leave the calculation mode in automatic all cells update (there are several worksheets involved) but the links also update, wasting time. Calculating each worksheet individually is not an option (there are too many) and leaving the calculation mode in manual is not an option either. Please help. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links Automatically refreshing in Excel 2007 | Excel Worksheet Functions | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Suppress Update Links dialog AND don't update links | Excel Programming | |||
Listbox not refreshing on update | Excel Programming | |||
Refreshing Links On "Calculate" | Excel Discussion (Misc queries) |