Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 14th 07, 04:59 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
Posts: 16
Default Updating Workbooks from multiple links Workbooks

I have a "Running Totals" Workbook that is linked to another workbook (Named
Sept) which is linked to another workbook (Named August) which is linked -
you get the idea - for the entire Fiscal year. Is there a way to update the
last Workbook (Running Totals) without opening and manually updating and
saving all of the other previous Workbooks?

Thanks,
Tim

  #2   Report Post  
Old December 15th 07, 03:34 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,118
Default Updating Workbooks from multiple links Workbooks

This isn't a solution.....just my "two cents worth":

From my experience, your linked workbook structure is a disaster waiting to
happen. On several occasions I've inherited extensive linked workbook
structures...usually after they've collapsed or become corrupted (source
folders deleted, files moved, files on a PC not currently connected to the
network, etc). Consequently, I completely avoid linking. If I need data
from another workbook, I make structure the "public data" as a table and
either write a macro to get it or use MS Query to pull it.

That being said...if you absolutely MUST link,
see if one of these websites helps:
http://www.dailydoseofexcel.com/arch...sed-workbooks/
http://www.rondebruin.nl/ado.htm#files


--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"TimJames" wrote in message
...
I have a "Running Totals" Workbook that is linked to another workbook
(Named
Sept) which is linked to another workbook (Named August) which is linked -
you get the idea - for the entire Fiscal year. Is there a way to update
the
last Workbook (Running Totals) without opening and manually updating and
saving all of the other previous Workbooks?

Thanks,
Tim







Reply
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
Updating Links from Closed Source Workbooks Fred Ernst Excel Discussion (Misc queries) 2 January 28th 07 05:14 PM
Updating multiple linked workbooks dk New Users to Excel 1 June 9th 06 12:33 AM
Updating links to closed workbooks goofy11 Excel Discussion (Misc queries) 0 March 23rd 06 04:28 PM
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


All times are GMT +1. The time now is 12:00 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017