ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   linked info (https://www.excelbanter.com/excel-worksheet-functions/147876-linked-info.html)

Sjones

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.

Bob Umlas

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.





All times are GMT +1. The time now is 07:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com