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
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