Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update a formula on an inactive sheet
Does anyone know how to update a formula on an inactive sheet? I would
like to create a formula on one sheet and have links to it on multiple sheets that depending on which sheet is activated, it will change the result... the problem is that once the sheet containing the formula becomes inactive, it does not update when a new sheet is activated... Neil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adv. Filter - Want to copy to inactive sheet | Excel Discussion (Misc queries) | |||
Adv. Filter - Want to copy to inactive sheet | Excel Discussion (Misc queries) | |||
Hyperlink inactive if sheet protected | Links and Linking in Excel | |||
Calling an inactive sheet... | Excel Programming | |||
macro to change data in inactive sheet | Excel Discussion (Misc queries) |