| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Linking to workbook
Hi, Let me explain the setup... I have 3 workbooks. wkbk1 contains a list of source data. wkbk2 contains pivot tables based on the source data. wkbk3 contains reports using the worksheet formula GETPIVOTDATA. When I open up wkbk1 and update the values in the report show #REF. However, When I then open up wkbk2 the values in wkbk1 update. How can I get the values to display on just opening wkbk1. A sample formula in the report is as follows: =GETPIVOTDATA("Sum of AOT GBPNet",'V:\Broker Disclosure\Reporting\[TD.xls]PT AOT Combined'!$A$5) TIA, Matt. -- MattShoreson ------------------------------------------------------------------------ MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472 View this thread: http://www.excelforum.com/showthread...hreadid=390539 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| Sumif Linking to Another Workbook error #VALUE! | Excel Discussion (Misc queries) | |||
| Linking Workbooks | Excel Worksheet Functions | |||
| linking cell value in one workbook to a cell in another workbook | Links and Linking in Excel | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
