I have been using vstack for a little while and came across a problem last night. I went to perform the function with a 3d reference of all the sheets and the formula returned a single 0 in the cell vstack was typed in.
This is also the same if I reference each page individually. However works on a single page.
Anybody else come across this issue?
(Sorry I can't put an example workbook up)
I tried replicating the issue but could not. The attached file contain a workbook with three sheets where I used VSTACK in a 3D reference. does this resemble what you are trying to achieve? If so, does it work on your end?
Hi thank you for the reply. Yes this is what I am trying to achieve. I have done the same formula for over 100 sheets before and worked OK.
The work around I have found so far is to take the work book where v stack doenst work, power query all the sheets into a new workbook mirroring the same format and layout, then apply the vstack and it works perfectly.
Tried this on 3 separate workbooks (one of which had over 170 sheets) and the work around holds.
Still can't figure out why it only works in this method now
Make sure the sheet with the formula is not between the sheets your referencing, otherwise you might get a circular reference.
