Broken Excel Macro

We have an Excel macro that suddenly stopped working. No changes have been made to the workbook. We have tried to fix known issues with this error but still receive an error. The error is "The Pivottable field name is not valid". We are looking to have this fixed immediately since we use this workbook often.