Open excel with a filter active an a certain value

[Elly Driesen-Schepens]

Hi,

I have an excel sheet created with an autofilter. In a Word document i want
to add a hyperlink to my excel but i only want to see specific information
(so i would like to filter on a specific value of one of my columns).

Example excel:
column 1 column 2
A 1
A 2
B 3
C 1
A 3
When I open the excel (via Word with hyperlink) I only want to see the rows
that contain value 'A' in column1.

Is this possible?
Thanks in advance!

 

[Barb Reinhardt]

I'd do this with an autoopen macro that filters the value on A.