Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
We are very puzzled about the amount of time it is taking to open Excel
spreadsheets containing links to other spreadsheets. We have been attempting to program all our reports into Excel and find that Lotus 1-2-3 from 1995 opens spreadsheets MUCH quicker. We've tried to find an Excel set-up that would help open the spreadsheets quicker but no luck. Another thing we've noticed is that our spreadsheets will not update the links to other spreadsheets after hitting the Calculate button unless we have all the linked spreadsheets open also. Example: Spreadsheet A picks up figures from spreadsheet B, C, and D. If we attempt to open Spreadsheet A, it will take us anywhere from 2 minutes to an hour to open if spreadsheets B, C, and D are NOT open. This does not happen in LOTUS 1-2-3 which has a setting to "update links upon opening". The ONLY way for us to open spreadsheet A quickly is to FIRST open spreadsheets B, C, and D. Also, if these other spreadsheets are NOT open then the figures in Spreadsheet A would NOT update. PLEASE HELP!!!! Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Links to other spreadsheets | Excel Discussion (Misc queries) | |||
Links to Multiple Spreadsheets | Excel Worksheet Functions | |||
File-Open Long Delay | Excel Discussion (Misc queries) | |||
i try to open Excel spreadsheets, and they open in wordpad-- | Excel Discussion (Misc queries) | |||
Spreadsheets Links | Excel Worksheet Functions |