PIVOT TABLE - SOURCE DATA - Urgent help!

[kinapatel]

Hello All,

Please can you assist me on the below issue I get frequently.

I have an excel report which comes from a system. The data shows both Local Currency information and USD Currency information, across multiple tabs.

In a separate excel workbook I copy and paste values all the Local currency data into 1 tab, and again copy and paste values all the USD currency data into a different tab (tab 2)

I then create a PIVOT Table on tab 1 (Local Currency) - this works fine

When I go to create another PIVOT Table on tab 2 (USD Currency) - the source data automatically picks up the data on the local currency tab, even though I am selecting the data on the USD Currency tab.

I have then gone on to 'change the source' on the pivot to change this to the USD Currency tab data, HOWEVER, it still reverts back to the Local currency tab.

It is really weird and I have no idea why this keeps on happening.

Note - The data on the Local Currency tab and the USD Currency tab have the same number of lines and the same number of columns. Only difference is the values

Please can anybody assist me with this problem?

Many thanks
Krishna