changing the path behind a button
 

Hi

My client had a button in excel 2002 that was linked to an xls sheet on our
server
Now the xls sheet has changed to another directory on this server
My client has now excel 2007 and still has this button linked to te wrong
directory

How can i change the path behind this button in ecxcel 2007?

Greetings
Jurgen

changing the path behind a button
 

I would think that you could change the source of the link using Edit Links
in the Connections group of the Data tab.

--
Jim
"derksj" wrote in message
...
| Hi
|
| My client had a button in excel 2002 that was linked to an xls sheet on
our
| server
| Now the xls sheet has changed to another directory on this server
| My client has now excel 2007 and still has this button linked to te wrong
| directory
|
| How can i change the path behind this button in ecxcel 2007?
|
| Greetings
| Jurgen