Value Error when activating content/updating content from other workbooks

Nattpappa

New Member
Joined
May 14, 2018
Messages
2
Hi!

I was tasked to create a relatively simple series of excel workbooks that connect to a main workbook.

I have several different districts that are gonna have their own budget workbook aswell as a report workbook from which the person in charge of that district can send out a small report without showing the entire budget file. The budget and report files grab data from a workbook where all sales are logged. Then there is also a main budget file that gathers data from the combined district files.

Everything connects, the data is correct, but whenever I open one of the files and I'm asked to activate content or get the prompt to update content, all cells that connect to other workbooks turn into value errors.
I have resolved this by going to Data > Links > Open files. This makes every cell update. I also tried changing the options to make the workbooks update without asking, but this turned into value errors and I had to go through the steps I mentioned.

Is there a way to make this process automated so that the files update data when opened without me having to manually edit links and open the linked files? A VBA? An option that I missed?

Thank you!
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Watch MrExcel Video

Forum statistics

Threads
1,122,162
Messages
5,594,615
Members
413,917
Latest member
devansh02

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
Top