When I open my excel file I get this error:
"The pivot table field name is not valid.."
I know what it means and how to fix it, but since I have a lot of pivot tables in this excel, how can I find which pivot table is causing the problem?
Or at least a list of all pivot tables in the excel?
MS could really think to specify WHERE the problem is, instead of just throwing an error not clear about what..
Thanks
Bookmarks