Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adv. Filter - Want to copy to inactive sheet Maki Excel Discussion (Misc queries) 7 January 20th 10 12:59 PM
Adv. Filter - Want to copy to inactive sheet Maki Excel Discussion (Misc queries) 1 January 12th 10 10:50 PM
Hyperlink inactive if sheet protected Tome de Souza Links and Linking in Excel 1 June 1st 09 01:59 PM
Calling an inactive sheet... RJH Excel Programming 1 July 17th 06 04:23 AM
macro to change data in inactive sheet Diana Excel Discussion (Misc queries) 1 April 28th 06 08:10 PM


All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"