Named ranges in an xlam workbook - references not being seen

Hi all
I have moved a controlling workbook to an xlam workbook as I have a need for two worksheets - 1 a product indexing worksheet and 2 a printable form.

The xlam macros have been added to a group in the main ribbon and as this workbook uses a backend DB and I have sorted all the server references for that.

While flicking through the processes I have noticed that references to named ranges in the product sheet are no longer activated

such as

Please Login or Register  to view this content.

as I can no longer view the ranges from the name manager. The question is are they actually there or how would I change the references to the ranges
Many thanks

As a stopgap I've had to hardcode the ranges, I tried declaring but no go

Please Login or Register  to view this content.