Partial Refresh

Status
Not open for further replies.

AllisterB

Board Regular
Joined
Feb 22, 2019
Messages
120
Office Version
  1. 365
Platform
  1. Windows
Hi
Firstly I am a newbie

When I do Data Refresh All the Refresh (while disproportionally long (10min for a few tables of 4k rows 30 Columns) is almost always only partial. I repaet teh refreshes and after say 4 get a full refresh.
I suspect that it may have to do with dependencies - or it may be something else.

My workbook is setup as follows:


I have in a workbook Query1 that queries Table A in the same workbook and outputs to a Table B.

SheetA has cells that refer to Table B via SUMIFS formulae.

Query2 queries SheetA and outputs to Table C

Table C is then Merged with other data in Query 3 and output to Table D.


Have a got dependencies that cause a partial refresh - If so, how do I solve this
If Not what else might be causing the partial refresh

Thank You
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Duplicate Reresh Not Working Fully

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,223,799
Messages
6,174,669
Members
452,576
Latest member
AlexG_UK

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