Linking two Excel Spreadsheets together

[rerz]

I have a query in Access that outputs to Excel, and after the output i have multiple columns to the side of that query that have logic (that can not be done in Access). I would like a way to export this excel spreadsheet, as if it was an Access query, to other Excel files.


Here is the reason I need this. Currently I create a copy of the tab and move it into other Excel files because the output from Access is extremely large and takes a long time to update, so i have multiple spreadsheets that use this information for different tasks. The problem occurs when I change the logic in the original file, the logic in the other files is outdated. I know about linking the files with a simple =(file location)/A1 , but that takes a long time to calculate all the cells. So i was wondering if there was a way where Excel would pretend that another excel file is like a query and could update off of that excel file so all of my outputs could be linked to one master file that would have the original Access query and have the logic always updated and consistent.

Thanks for the help and let me know if you have any other questions.

[FDibbins]

you can always, and easily, reference 1 excel file to another, as you suggested. im a little confused tho as to what you are trying to achieve...what gos to where, from where, sorry.

would a few pivot tables not help you sort your data for you, and make it easier to manage? I have done something similar where my excel file is linked to an access data base, and i then created a series of PT's to summarise/analyse that data into a more managable format.

[rerz]

I guess the best way to explain this is imagine that this one "master" excel document (the combination of a query and other logic done in excel) is an access query. We use then use this "master" to create other excel spreadsheets (for example: one for shipping history, one for positions, inventory, orders, billings, ect.) This master file, is already massive and if we created multiple pivot tables for every desired output it would take hours to calculate.

So our workaround is to take the "master" spreadsheet's tab and copy it to a new file for each output. So now we have a inventory.xlsm file that has all of the "master" information and we create PT's in that file for the desired information related to inventory (and repeat the process for all outputs)

The problem occurs when we realize an error in our logic in the "master" and have to go back and edit the master to update for a mistake. Since we had already copied the tab for the output files, they all contain faulty logic, and without a proper link, the logic will remain faulty unless changed in every output.

I dont know if that helps explain it better, but i hope it does. Please let me know if you have any ideas. Thanks!