There MUST be a more efficient way

wisewood

Board Regular
Joined
Nov 7, 2002
Messages
193
We have a spreadsheet for keeping track of invoices, what they're for, how much is owed etc etc.

Each invoice is saved in a directory, and then the master sheet looking at specific cells within those invoices to get their values - eg. =SUM('G:\Marketing\Invoices\[MISC2654.xls]Sheet1'!$E$34:$R$34)

Now, the problem is, we now have almost 3000 of these invoices, and the master sheet takes a VERY long time to open because of all the linked data held in other .xls files.

is there another, more efficient way, to collect the data from these external files? Perhaps a way to load the information into the master sheet only once, and then set the value of that cell to save the need to load it in again? That way only updates are loaded, rather than ALL the information every time.

please say this makes sense lol
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,181,717
Messages
5,931,646
Members
436,796
Latest member
parthibanmuniswamy

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