Forum Discussion
Solved
Cant find named range
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 b...
Thank 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.
Hi Hans
I have messaged you with a copy of the spreadsheet HansVogelaar
Thanks
Thank 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.
- It worked thanks