Hi there!

I am new to this forum. First of all: Hi out there!

Now my question. I am using Excel 2007 and I have a problem with seperating an Excel-file from a pivot table.

What I want to do:
I got my Excel-File and I want to create a Pivot-table out of it. After creating the Pivot-table, I want to seperate it from the native excel-file and save the pivot table for working with it.

What I did:


I created the pivot-table. That wasn't a problem. After creating the pivot table, i right clicked on the tab under it and copied it in another, new excel file. Everything was still fine.
I saved the pivot file, closed it, changed some information in my native excel file and opened the pivot file to check, if updating the pivot file works. But it didn't work, saying it didn't find the connections.

What can I do?


PS: Sorry for my bad english, I hope you understand my problem.

Thanks for any help!
Kevin