Refreshing a table

P

piresmdb

Board Regular
Joined
Feb 3, 2011
Messages
67
Dear all,

I am trying to refresh an excel file that is connected to SQL and I am getting the message that a pivot table cannot overlap another pivot table. I had only one PT that derived form the table that is refreshed but I have linked it to another table Nonetheless I still getting the same message all the time.

Any suggestion to overcome this problem?

Best regards
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
You must log in or register to reply here.

Similar threads

D
  • Question Question
Pivot Table Refresh Issue
Replies
7
Views
784
Alex Blakenburg
A
R
  • Question Question
Data Model Error - Effecting all versions of the same workbook
Replies
0
Views
335
Rollnation3
R
L
  • Solved
Code in excel VBA to refresh SAS tables instead of pivot tables
Replies
2
Views
544
Luigiportucale
L
H
  • Question Question
VBA code to open an excel workbook, Refresh the query (PQ), once it has finished running, save and close the workbook
Replies
2
Views
911
hananak
H
S
  • Question Question
Filter in Pivot Table Field List Clearing when The Pivot Table Is Refreshed
Replies
1
Views
611
arun_eagertolearn
A

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top