Nanaia

Board Regular
Joined
Jan 11, 2018
Messages
224
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Is there a way to link workbook files so that workbook A (the master) feeds into workbook 1 & 2 without workbook A always having to be open so you can see the data in workbook 1 & 2? We want to enter the data in the master and have select daily data put into workbook 1 and weekly data put into workbook 2. I can get them linked, but in order to see the data in workbooks 1 & 2 you have to have the master open or you get an error. I'm trying to determine whether Excel is the program to do this with or if Access would be better. Does anyone have any experience with this that they can/will share?
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,768
You don't have to have WB A open to have the links work. Maybe your Security settings need adjusting
Choose File - Options - Trust Center - Trust Center Settings - External Content - Security Settings for Workbook Links
 

Watch MrExcel Video

Forum statistics

Threads
1,109,000
Messages
5,526,186
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top