I have inherited a spreadsheet which has pivot tables based on a named range. I am trying to make changes to the source data but I cant seem to find it. I can see the name in hte cell reference box but when i click on it nothing happens. It doesnt appear in the Name Manager. I have tried the find and GoTo the name range but nothing is happening. The person who created the spreadsheet is no longer available and it is to large to start from scracth. Any suggestions?

By the way I have searched for suggestions and have tried to click on the name in the cell reference field and i have also used the GoTo they have not worked. I can see the name but it is not taking me to the cell range

Thanks in advance

​I have inherited a spreadsheet which has pivot tables based on a named range. I am trying to make changes to the source data but I cant seem to find it. I can see the name in hte cell reference box but when i click on it nothing happens. It doesnt appear in the Name Manager. I have tried the find and GoTo the name range but nothing is happening. The person who created the spreadsheet is no longer available and it is to large to start from scracth. Any suggestions? By the way I have searched for suggestions and have tried to click on the name in the cell reference field and i have also used the GoTo they have not worked. I can see the name but it is not taking me to the cell range Thanks in advance  Read More

​