SOLVED

Cant find named range

Copper Contributor

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

4 Replies

@LindaBee05 

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.

Hi Hans
I have messaged you with a copy of the spreadsheet @HansVogelaar 

Thanks

best response confirmed by LindaBee05 (Copper Contributor)
Solution

@LindaBee05 

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
1 best response

Accepted Solutions
best response confirmed by LindaBee05 (Copper Contributor)
Solution

@LindaBee05 

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.

View solution in original post