LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 84
Default Significant DELAY to open spreadsheets containing regular links?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Links to other spreadsheets Compatibility link Excel 2007 Excel Discussion (Misc queries) 8 January 25th 08 10:15 PM
Links to Multiple Spreadsheets Spreadsheet Linking Flexibility Excel Worksheet Functions 4 April 1st 07 01:18 PM
File-Open Long Delay John Excel Discussion (Misc queries) 3 May 5th 06 04:15 PM
i try to open Excel spreadsheets, and they open in wordpad-- mikekeat Excel Discussion (Misc queries) 2 October 1st 05 10:13 PM
Spreadsheets Links SJC Excel Worksheet Functions 1 March 21st 05 06:37 PM


All times are GMT +1. The time now is 09:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"