Hello,
I have a spreadsheet, data is always being added to the spreadsheet, and therefore I need to update the PivotTable.
However, I'm frequently getting error messages upon refresh.
Imgur: The most awesome images on the Internet
With the first one, I do what the error message says, I close the workbook, reopen, refresh the PivotTable and it works!
Imgur: The most awesome images on the Internet
With the second error message, this seems to crop up about 60% of the time.
I just don't understand it, it's very intermittent, the data I'm inputting (copy and pasting) is consistent with the previous data thats there.
With the PivotTable I have, I tick the 'Add this data to the Data Model', because my PivotTable requires distinct count function.
Might this have something to do with it? Does anyone have any experience of this error messages?
Thanks!
Edit: I should add I also change the data sample to the smallest range to see if that works (like four cells, two rows and two columns) and still getting these messages.
I have a spreadsheet, data is always being added to the spreadsheet, and therefore I need to update the PivotTable.
However, I'm frequently getting error messages upon refresh.
Imgur: The most awesome images on the Internet
With the first one, I do what the error message says, I close the workbook, reopen, refresh the PivotTable and it works!
Imgur: The most awesome images on the Internet
With the second error message, this seems to crop up about 60% of the time.
I just don't understand it, it's very intermittent, the data I'm inputting (copy and pasting) is consistent with the previous data thats there.
With the PivotTable I have, I tick the 'Add this data to the Data Model', because my PivotTable requires distinct count function.
Might this have something to do with it? Does anyone have any experience of this error messages?
Thanks!
Edit: I should add I also change the data sample to the smallest range to see if that works (like four cells, two rows and two columns) and still getting these messages.
Last edited:
