I use a pivottable to organise data in a list and then use the getpivotdata formula to pull the data into a customised report.
I have run into a problem now where I try to copy the file and create a new one for the present week. I change the source data however the getpivotdata formulas all now show ref! error. I've checked the formula and see nothing wrong. Can anyone help me? please copy your response to [email protected]
Bookmarks