Sep 16 2024 03:55 AM
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
Sep 16 2024 05:21 AM
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
Sep 16 2024 05:33 AM - edited Sep 16 2024 05:51 AM
Hi Hans
I have messaged you with a copy of the spreadsheet @HansVogelaar
Thanks
Sep 16 2024 07:05 AM
SolutionThank you.
Right-click any of the sheet tabs, then select Unhide... from the context menu.
Select Extract in the list of hidden worksheets, then click OK.
Activate the Extract sheet. It contains a table also named Extract. This is the source of the pivot tables.
It will now be listed in the Name Manager since it is not hidden anymore.
Sep 16 2024 07:05 AM
SolutionThank you.
Right-click any of the sheet tabs, then select Unhide... from the context menu.
Select Extract in the list of hidden worksheets, then click OK.
Activate the Extract sheet. It contains a table also named Extract. This is the source of the pivot tables.
It will now be listed in the Name Manager since it is not hidden anymore.