Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Issues
In my spreadsheet I have links with files that have very similar names, but
in different directories -- IE Bus A - Forecast 1, Bus A - Forecast 2 -- and is pulling the same data from each Spreadsheet: A B 1 =c:\Jan\Bus A - Forecast 1!C2 2 =c:\Feb\Bus A - Forecast 2!C2 Here is the issue -- Every time I either (a) insert a line in the spreadsheet or (b) open up either linked file -- the cell with the linked data turns to #VALUE! and then I have to open each file to refresh all of the links. Any ideas on why this is happening. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Refresh Issues when linking Access queries to Excel | Excel Discussion (Misc queries) | |||
datetime format issues when linking access to excel | Excel Discussion (Misc queries) | |||
Cut and Paste issues | Excel Discussion (Misc queries) | |||
PDF hyperlink issues | Excel Discussion (Misc queries) | |||
Issues with sorting | Excel Discussion (Misc queries) |