Excel 2007 Data Query parameters

[TechieTony]

Hello all,

Im working with excel 2007 for the first time and I seem to be having an issue setting parameters on my data. I remember in MS query I could go to my value and use [] to create a prompt for users. I read that its contained in

Connections -> Conn properties -> Definition and Parameters

But my options are greyed out regardless of what I do to the data that im importing..... anyone might have a clue as to what im doing wrong here ?

Thanks much
Antony

 

[xlhelp]

I don't have 07 in front of me, but off-hand I would say you are still in compatability mode (look on the Title bar).

You will probably need to convert it to XLSX version before some these become alive.

I just LOVE XL07. Now, If you believe that.........

Member- AAAA Association Against Acronym Abusers