Dynamic name range/pivot table

  • Thread starter Thread starter Hans
  • Start date Start date
H

Hans

I made a dynamic name range (with OFFSET) that refers
to a pivot table that is linked to an external (FoxPro)
datasource. When I use this name in data validation, I get
the usual drop-down list and this works fine.

However, when I manually enter data I always get the error
message that my value is not valid, even thought the value
I entered is available in the drop-down list.

Does anyone know if it is possible to solve this without
making an extra table that refers to the pivot table?

Many thanks in advance for your help,
Kind regards
Hans
..
 
----- Hans wrote: ----

I made a dynamic name range (with OFFSET) that refers
to a pivot table that is linked to an external (FoxPro)
datasource. When I use this name in data validation, I get
the usual drop-down list and this works fine.

However, when I manually enter data I always get the error
message that my value is not valid, even thought the value
I entered is available in the drop-down list

Does anyone know if it is possible to solve this without
making an extra table that refers to the pivot table

Many thanks in advance for your help
Kind regard
Han
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation Pivot Table 2
Dynamic data ranges in pivot tables 3
Pivot Table Drop Downs 3
Pivot table filter list - listing irrelevant subcategorys 1
automatically update pivot tables when dynamic named range is expa 10
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Pivot Table using dynamic worksheets 2
pivot table and critera range filter 1

Back
Top