Pivot Table From Another Workbook

[mouse88]

I have a workbook called MainData which contains a table.

I have another workbook called TeamView which needs to have a pivot table based on the table in the MainData workbook.

I tried to isert the pivottable and click to the table in the MainData workbook but instead of referencing the table it only references the cells i select to if data gets added to the main table it won't be included in the pivot table.

I tried to set up a connection to the table but all the values came in the pivot table as 1 which is incorrect.

Any ideas?

Thanks

Matt

 

[crook_101]

Hi Matt,

Think tis will solve your problems..

http://www.contextures.com/xlPivot08.html

Ian

 

[mouse88]

Dont think this is quite what I was after.

I wan't the pivot table to automatically include any data that is added to the table in the main work book. I don't really want to have to go in to the main work book and change a named range or edit the source of the pivot table.

This would be all well and good for me but for other users that aren't to knowlegable with excel it may be a problem.

 

[mouse88]

I managed to get it kinda working. I clicked and highlighted all of the table so it references the other workbook and then replaced the range with the name of the table. This works but only if the other work book is open. If it is not open it says invalid range.

 

[mouse88]

Anyone

 

[mouse88]

Nobody?