refreshing pivot tables

%3CLINGO-SUB%20id%3D%22lingo-sub-1551742%22%20slang%3D%22en-US%22%3Erefreshing%20pivot%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1551742%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20series%20of%20dashboards%20attached%20to%20a%20database%20and%20have%20been%20refreshing%20the%20pivot%20tables%20without%20any%20problems%20until%20today.%20When%20I%20%22refreshed%20all%22%20the%20last%20time%2C%20the%20background%20query%20was%20taking%20forever%20so%20I%20followed%20some%20suggestions%20by%20the%20groups%20to%20disable%20the%20background%20option%20in%20the%20connections%20(I%20did%20that%20on%20all%20the%20power%20queries%20I%20had%20in%20the%20database).%3C%2FP%3E%3CP%3EHowever%2C%20some%20data%20I%20had%20replaced%20in%20the%20database%20was%20not%20being%20updated%20in%20the%20pivot%20tables.%20I%20tried%20refresh%20all%20and%20also%20refreshed%20individual%20pivot%20tables%2C%20I%20have%20linked%20the%20pivot%20tables%20again%20to%20the%20database%20with%20%22change%20data%20source%22%2C%20and%20nothing%20seems%20to%20work.%20I%20get%20messages%20like%20the%20ones%20below.%20I%20tried%20to%20change%20the%20Excel%20settings%20and%20unchecked%20%22alerts%20before%20overwriting%20cells%22%20and%20it%20is%20not%20working.%20I%20also%20tried%20to%20add%20rows%20between%20pivot%20tables%20in%20case%20overlapping%20is%20a%20problem%20but%20it%20doesn't%20seem%20to%20solve%20the%20problem.%20I%20had%20not%20problems%20until%20yesterday%20so%20I%20am%20really%20confused.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20really%20welcome%2C%20I%20am%20attaching%20database%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYolanda%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22YolandaBL_1-1595972875785.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F208610i8ABF42CFC05ED870%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22YolandaBL_1-1595972875785.png%22%20alt%3D%22YolandaBL_1-1595972875785.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22YolandaBL_2-1595972884757.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F208611i294D78EC8AF0F08E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22YolandaBL_2-1595972884757.png%22%20alt%3D%22YolandaBL_2-1595972884757.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1551742%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1563424%22%20slang%3D%22en-US%22%3ERe%3A%20refreshing%20pivot%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563424%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F709059%22%20target%3D%22_blank%22%3E%40YolandaBL%3C%2FA%3E%26nbsp%3BIt%20seems%20there%20are%202%20(or%20more)%20pivot%20tables%20on%20the%20same%20worksheet%2C%20and%20when%20this%20one%20tries%20to%20update%2C%20it%20can't%20because%20it%20would%20'spill'%20into%20the%20other%20one(s).%3C%2FP%3E%3CP%3EI%20suggest%20moving%20them%20to%20separate%20worksheets.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a series of dashboards attached to a database and have been refreshing the pivot tables without any problems until today. When I "refreshed all" the last time, the background query was taking forever so I followed some suggestions by the groups to disable the background option in the connections (I did that on all the power queries I had in the database).

However, some data I had replaced in the database was not being updated in the pivot tables. I tried refresh all and also refreshed individual pivot tables, I have linked the pivot tables again to the database with "change data source", and nothing seems to work. I get messages like the ones below. I tried to change the Excel settings and unchecked "alerts before overwriting cells" and it is not working. I also tried to add rows between pivot tables in case overlapping is a problem but it doesn't seem to solve the problem. I had not problems until yesterday so I am really confused. 

 

Any help really welcome, I am attaching database,

 

Yolanda 

 

YolandaBL_1-1595972875785.png

 

YolandaBL_2-1595972884757.png

 

1 Reply

@YolandaBL It seems there are 2 (or more) pivot tables on the same worksheet, and when this one tries to update, it can't because it would 'spill' into the other one(s).

I suggest moving them to separate worksheets.