View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Trouble opening hyperlinks to shared folder

Are you sure the hyperlinks still point to the correct location?

You may want to check that, then change the hyperlink base to C:\ (or
\\doesnt\exist) so that excel doesn't try to fix them.

ps. I always like using the =hyperlink() worksheet function. It seems better
behaved to me.

Richard wrote:

My computer is on an internal network and I have created a shared folder that
is accessable to everyone on the network.

I have created an excel file with hyperlinks to files in this shared folder.
The hyperlinks themself only list the filename. The
File/Properities/Hyperlink Base is set to the shared folder, i.e.
\\Erd-wk-han7542d\CRREL Reports\Temp\ where Erd... is name of my computer,
"CRREL Reports" is shared folder, "Temp" is subfolder .

The links work for some people on the network, but most cannot open the
files. They get generic error "Cannot open specified file" when clicking on
the hyperlink. These people can reach the hyperlinked files using MS
Explorer, but not throught Excel.

How set up folder and hyperlinks in Excel file so everyone can open
hyperlinked files.
--
Richard


--

Dave Peterson