Hello,
I am struggling with this one. I have a workbook that is shared.
Since you can not use PivotTables with a shared file, I have created
seperate workbook with a PivotTable that pulls the data from the firs
wookbook. Updating the PivotTable has been fine until all of sudden
received an error "The PivotTable field name is not valid". The firs
time I received this error, I couldn't figure it out, so I recreate
the workbook with the PivotTable. That worked for about a month, an
the error has come up again. Help....why is this happening?

Any help or ideas would be truly appreciated! Thank you.
Mik

--
Message posted from http://www.ExcelForum.com