Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
UMP-07
 
Posts: n/a
Default Why aren't links between tabs in same workbook automatically updat

I have links between cells in a single Excel workbook, but then I change the
data in the source cell it is not consistantly updating it in the linked
cell. Is this common and how do I fix it?
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

If you mean links like this
=Sheet2!B1

See ToolsOptions..Calculation
Set it to automatic

--
Regards Ron de Bruin
http://www.rondebruin.nl



"UMP-07" wrote in message
...
I have links between cells in a single Excel workbook, but then I change
the
data in the source cell it is not consistantly updating it in the linked
cell. Is this common and how do I fix it?



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
Updating links to new workbook with same format Andy Links and Linking in Excel 1 January 12th 05 08:22 AM
Removing links to other worksheets from within a workbook rjb Excel Discussion (Misc queries) 2 December 9th 04 08:04 AM
move the worksheet tabs in a workbook to left Boriss Excel Discussion (Misc queries) 1 December 6th 04 08:28 PM
Workbook Tabs Graham Parkinson Excel Discussion (Misc queries) 2 December 2nd 04 03:07 PM
Links in formulas change when another user runs a workbook L Mehl Excel Discussion (Misc queries) 2 November 27th 04 09:27 PM


All times are GMT +1. The time now is 02:58 AM.

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"