Updating Multiple Excel Files

[maeyks]

Dear all,

Here is what i did:
1. to avoid clutter or bulk files, i created recipes 1 to 20, separately. so i have 20 excel files
2. i created the 21st file which will consolidate the 20 files altogether, that is, using pivot. what i hope to achieve here is, i will make a central ordering system, that will compute how much of each recipe on all of these 20 files.

the only problem is, the pivot table won't update from the 21st file (consolidated) when i enter the orders. it updates itself when i open the excel files, separately.

is there a way that it will update itself without anymore opening all the files i created?

help please.


maeyks

 

[GlennUK]

Did you make your summary pivot this way?

http://blog.contextures.com/archives/2010/08/30/macro-creates-excel-pivot-table-from-multiple-files/

 

[maeyks]

Did you make your summary pivot this way?

http://blog.contextures.com/archives/2010/08/30/macro-creates-excel-pivot-table-from-multiple-files/

Hi Glenn,

Thanks for the reply. Actually I did not use any macro program.


Maeyks

 

[GlennUK]

You said:

2. i created the 21st file which will consolidate the 20 files altogether, that is, using pivot.

If you used the method in the link, surely you'd get exactly what you want.