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!
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!
