Hi I have this file created by a colleague for some reporting. Was working perfectly till last year. This year when I populated data, the graphs were not getting updated. The table it was referring to showed some #Value error.
If that's not helpful in resolving your situation, then please come back with a more complete description and, ideally, posting a copy of the spreadsheet in question on OneDrive or GoogleDrive (just making sure there's no confidential information contained in it). Paste a link here granting access with editing privileges.