Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 3
Default Links between two workbooks

Hi,

Can anyone guide me to understand, which is the best way of linking workbooks.

I have a master budget which pulls data from several other workbooks.

However, there are several drawbacks for such linkages. If the destination file is opened before the source file or if someone else is accessing the source file which i do then in such situations the destination file give ref# error.

In short, I want to know which is the best way of linking workbooks together.
Also, if macros could be a option.

Thanks,
Balesh
  #2   Report Post  
Junior Member
 
Location: Mumbai
Posts: 1
Default Combine workbook in Excel

This can help you. i guess please follow the step, site also have how to combine multiple worksheet or workbook

Combine or Merge Excel Files into one Excel spreadsheet using Macro
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
Slow opening links between workbooks with links created in 2003 Russell Excel Discussion (Misc queries) 0 December 14th 09 02:59 PM
Updating Workbooks from multiple links Workbooks TimJames Excel Worksheet Functions 1 December 15th 07 03:34 PM
Links between workbooks British1942 Excel Worksheet Functions 3 January 11th 07 04:47 PM
Links between workbooks Eddie Excel Discussion (Misc queries) 0 April 18th 05 03:21 PM
Links to other workbooks Darrell Wesley[_2_] Excel Programming 2 January 12th 05 08:15 PM


All times are GMT +1. The time now is 12:52 PM.

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

About Us

"It's about Microsoft Excel"