#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default linked info

I have a workbook with a summary page linked to several source documents. The
value on the summary page cells is not the same as the value on the source
document cells. "Links" under "Edit" is not highlighted so I can not use this
function.
I would like the cells in the summary page to display the accurate amount
linked from the source document.

I'm using Microsoft XP Professional.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 301
Default linked info

Sounds like you're "linking" to other sheets in the same workbook, otherwise
you would see Edit/Links being enabled. Then, it seems like you have
calculatino set to manual. Just a guess.
Bob Umlas

"sjones" wrote in message
...
I have a workbook with a summary page linked to several source documents.
The
value on the summary page cells is not the same as the value on the
source
document cells. "Links" under "Edit" is not highlighted so I can not use
this
function.
I would like the cells in the summary page to display the accurate amount
linked from the source document.

I'm using Microsoft XP Professional.



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
Keeping cell info intact when sorting worksheets w/some linked cel judie Setting up and Configuration of Excel 0 April 1st 07 10:12 PM
varying validation info based on preceding info georgejl Excel Discussion (Misc queries) 1 November 9th 06 10:31 PM
Tables, How do I make new info push existing info to the next row? PeteL Excel Worksheet Functions 1 April 16th 06 09:46 PM
Link info in one cell to info in several cells in another column (like a database) hansdiddy Excel Discussion (Misc queries) 1 February 22nd 06 02:27 AM
Show info in linked cells in dif workbks? noclue Excel Worksheet Functions 1 February 9th 05 08:39 PM


All times are GMT +1. The time now is 04:34 AM.

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

About Us

"It's about Microsoft Excel"