Forum Discussion
Cant find named range
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.
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
ThanksThank 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
