Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Linking and errors
Hi All,
I have sixty odd spreadsheets (one for each staff member) that contain a lot of data spreadout over a number of tabs and cells. I have a single spreadsheet with sixty odd tabs that links all the data i require in a tidy format, however i have some problems. 1. A number of the linked cells after updating have #N/A in them, this is usually but not exclusively in the top seven linked cells from one particular field (Name). If i open the individual spreadsheets these #N/As disappear but opening this many large spreadsheets takes a long time. Is there a fix for this? 2. Additionally when updating the links, 2 of the 60 spreadsheets say 'cannot read file', these individual spreadsheets are the same as the other 58 and again the problem is fixed by actually opening the individual 2 spreadsheets but is a pain to do. Is there any advice on this? 3. The spreadsheet with the links is huge(!), i doubt it, but is there any way to shrink this down? Thanks Emma |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking arrays and Worksheet names | Excel Worksheet Functions | |||
Linking worksheet functions and arrays - Doozie | Excel Discussion (Misc queries) | |||
#name? errors on spreadsheet | Excel Discussion (Misc queries) | |||
linking problem with closed documents | Excel Worksheet Functions | |||
conditional forming causing linking errors | Excel Worksheet Functions |