This is the worst necro post I've ever seen I know. Sorry not sorry.
Google brought me here and the above function from debra does EXACTLY what I needed. well did do what I needed.
my objective is to quickly check if a refreshed pivot table is capturing all the new data that was put into it. I have 2 boxes with a 3rd that asks if they are equal and is conditionally formatted to give a color depending on the result.
1st box has the formula: =ROUND(LEFT(RIGHT(A1,8),5),0) with "A1" being the PTSOURCE function result debra mentions above (there are ~10k rows so I wanted the 5 digit row # to compare against the total non blank rows in the 2nd box)
2nd box has the formula: =(COUNTA(Surveillances!A:A)) which just counts how many cells in the first column have data.
a button fires the below macro that refreshes the data.
This worked fine until I realized that the refresh macro was stored in my personal workbook folder and not the file itself. I moved where it pulled from and ever since the function returns only a #value error. I typed it more than once perfectly, copied/pasted, etc. I replaced it into my personal folder as well as the workbook and it still won't work.
any ideas?
Thanks.
Bookmarks