how do I add (and not replace) data into Power Pivot ?

[ExcelTeen]

[TABLE="width: 1021"]
<tbody>[TR]
[TD]Hello,[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]a simple question about Power Pivot, that I am not very familiar with …[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]I would like to know how I can add (append ?) - and not replace - data in a Power Pivot model.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]In a nutshell, I analyze 4 great regions (Europe - America - Asia - Africa), each in an Excel file requiring lots of operations that I automatized thanks to VBA[/TD]
[/TR]
[TR]
[TD]The sum of the 4 regions is over Excel limit, so I am thinking of putting them in Power Pivot[/TD]
[/TR]
[TR]
[TD]But when I try to import the 4 regions, the existing data gets replaced so that I only have the last imported region … [/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]How can I append and not replace the existing data ?[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]In advance, thank you for your help[/TD]
[/TR]
</tbody>[/TABLE]

 

[sandy666]

What does the excel user do?
tries trial and error methods
what does a good excel user do?
reads the creators' manual