LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 23rd 06, 04:28 PM posted to microsoft.public.excel.misc
Posts: n/a
Default Updating links to closed workbooks

I have a report template full of formulas. I'm using a variety of
Index/Match formulas to find 2 criteria and return the desired result. I'm
also using Sumproduct to sum columns based on 2 criteria. As you would
expect, with these array formulas it takes a while for Excel to perform all
the calculations. There are 4 workbooks that I'm saving over each week that
supply the data for my template report workbook. If I save over these 4
workbooks, then open them up, then open up my template, it takes the template
about 6.5 minutes to update. This isn't too bad. What I would like to do is
Save over the 4 workbook files. Then just open the report template and
select update links. When I tried to do this yesterday afternoon, I hit
update links at about 5 pm and left for the day. When I came back in this
morning, the screen on my computer still had the update links box
looked like no progress was made and Excel was frozen. I tried again this
morning and the same thing happened. The report template and the referenced
files are all in the same folder on a network drive. Is there a reason why I
have to have all the files open in order for the template to update? Why
won't it update the closed files?



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 auto update on some workbooks but not others Tasza Excel Worksheet Functions 1 October 25th 05 01:04 AM
Excel 2003 links are not updating between workbooks Tami C Excel Worksheet Functions 3 October 11th 05 02:03 AM
index & match with links for updating to other workbooks wrpalmer Excel Worksheet Functions 3 July 20th 05 03:18 PM
Links between workbooks Eddie Excel Discussion (Misc queries) 0 April 18th 05 03:21 PM
Updating Old Workbooks Paulie Excel Worksheet Functions 0 March 1st 05 07:11 PM

All times are GMT +1. The time now is 10:45 AM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017