| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to stop #REF! on linked cells in complex spreadsheets
Is it because you are linking to a pivot table? Or are you linking to plain
data/text fields? "Fatsofoureyes" wrote: I have a spreadhseet with links to several workbooks involving complex functions. If the linked workbooks are all open there is no problem. If I save the spreadsheet and re-open when the linked wworkbooks are shut all the formulas show as #REF! How can I stop this happening |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update linked cells within a workbook??? | Links and Linking in Excel | |||
| Two spreadsheets linked - moving cells | Excel Discussion (Misc queries) | |||
| In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
| stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions | |||
| listing linked cells | Excel Worksheet Functions | |||
Linear Mode
