Saving changes made to data that appears to be link to a PivotTable

[nforero9]

Hi,
Im trying to make changes on data that appears to be linked to PivotTables. When I update the fields i need to change, it appears to work acordingly, however, once i save and close the workbook and reopen it, my changes appear to not have been saved, i cant seem to find the source of this problem as i am fairly new to VBA coding and PivotTables.

below is the code that had been inserted in the sheet that filters the data, im not sure if the problem could be here:
Option Explicit
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
End Sub
Private Sub Worksheet_Calculate()
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
Private Sub Worksheet_Deactivate()
End Sub
Private Sub Worksheet_PivotTableAfterValueChange(ByVal TargetPivotTable As PivotTable, ByVal TargetRange As Range)
End Sub
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub

In addition, the sheet has individual declarations listed under the names below, as each has sifferent codes
-Activate
-BeforeDoubleClick
-BeforeRightClick
-Calculate
-Change
-Deactivate
-FollowHyperlink
-PivotTableAfterValueChange
-PivotTableBeforeAllocateChanges
-PivotTableBeforeCommitChanges
-PivotTableBeforeDiscardChanges
-PivotTableChangeSync
-PivotTableUpdate
-SelectionChange

and the entire workbook module has declarations listed under the following names:
-Activate
-Addinstall
-Adduninstall
-AfterSave
-AfterXmlExport
-AfterXMLImport
-BeforeClose
-BeforePrint
-BeforeSave
-BeforeXMLExport
-BeforeXMLImport
-Deactivate
-NewChart
-NewSheet
-Open
-PivotTableCloseConnection
-PivotTableOpenConnection
-RowsetComplete
-SheetActivate
-SheetBeforeCDoubleClick
-SheetBeforeRightClick
-SheetCalculate
-SheetChange
-SheetDeactivate
-SheetFollowHyperlink
-SheetPivotTableAfterValueChange
-SheetPivotTableBeforeAllocateChanges
-SheetPivotTableBeforeCommitChanges
-SheetPivotTableBeforeDiscardChanges
-SheetPivotTableChangeSync
-SheetPivotTableUpdate
-SheetSelectionChange
-Sync
-WindowActivate
-WindowDeactivate
-WindowResize

If anyone can please help me, that would be great!