HELP!! Creating a hyperlink to a specific sheet in an excel workbo

[janabanana]

I have Access 2000. I have created a column for my hyperlinks in my database.
I have even created the link. However, it will not let me narrow down the
destination/address to a specific sheet in my Excel file.

When I try to tweak the address when editing the hyperlink, it doesn't seem
to work. In the address, after the .xls, I have added #'name of sheet'
(pound sign and then the name of the sheet), and I have also tried -'name of
sheet' (dash sign and then the name of the sheet) what am I doing wrong?

 

[janabanana]

this is the path i am typing for the link in access:

file:///\\(path to my UPS sheets)\UPS%20MAILING%20SHEETS.xls#'ANGIE BERRS'

Angie Berrs is the name of the specific sheet in the file UPS MAILING SHEETS.
why will it not work?

Also, I have tried selecting a cell in the UPS file, clicking copy, then
going to the field in Acess and when I click Edit, the "paste as hyperlink"
option is not clickable.