Correct way to link different workbooks

wilwong1971

New Member
Joined
Oct 10, 2018
Messages
1
Hi

I'm new here and hope everyone is well!

I have a spreadsheet a friend asked me for help, it's a meal planner spreadsheet that has sheets within (one of which is 'ingredients' and has a master of all ingredients in there) other sheets that are breakfast, lunch, recipes etc link to this with drop down and calculate calories accordingly.

Works well when all the sheets are in the same workbook, but she is trying to link the ingredients into separate workbooks that link to this one sheet 'ingredients' .. i think she copies and paste her existing tab sheets to a new workbook and it fails to update.

What is the best practice to link separate workbooks that link and update properly into the master 'ingredients' sheet?

attached spreadsheet https://1drv.ms/x/s!AjmIJ7StZhbRgbQLyB-voGKPope0Ag
thank you all :)
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Forum statistics

Threads
1,223,911
Messages
6,175,324
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top