I recently upgraded one computer to excel 2003. When a hyperlink is created
in Excel 2003 I can not open it in excel 2000 (on my lap top). As message
comes up saying path or file name may have changed.
--
I.R. Clubbe
One possibility nothing to do with hyperlinks.
It is not a good idea to copy your toolbars file (.xlb) between different
versions of Excel, that is one possibility. Check the assigned macros
on your menus and toolbar buttons to see if they are referring to the
wrong location. If that is the problem I would suggest documenting
what you have see www.mvps.org/dmcritchie/excel/barhopper.htm
and then you can recreate them, as noted you would have to save
your button images.
Can you give an example of a hyperlink that gets the error message,
and the exact wording of the error message as that is what would
have to be searched on.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm
quot;Ruthquot; gt; wrote in message ...
gt; I recently upgraded one computer to excel 2003. When a hyperlink is created
gt; in Excel 2003 I can not open it in excel 2000 (on my lap top). As message
gt; comes up saying epath or file name may have changed.
gt; --
gt; I.R. Clubbe
Hi David
Thanks for your reply. Originally the folder with hyperlinks was created in
excel 2000 it worked on the network between two computers. when one computer
broke down I copied the folder onto excel 2003. I can open the hyperlinks
until I get to the final one then I get the following message. 'PZ
Thursday.xls' could not be found. Check the spelling of the file name, and
verify that the file location is correct. If I repeat the Hyperlink on my
second computer in excel 2000 I can then open it and the details on the open
file is as was entered on the excel 2003. Hope you can help thanks. Ruth
--
I.R. Clubbequot;David McRitchiequot; wrote:
gt; One possibility nothing to do with hyperlinks.
gt;
gt; It is not a good idea to copy your toolbars file (.xlb) between different
gt; versions of Excel, that is one possibility. Check the assigned macros
gt; on your menus and toolbar buttons to see if they are referring to the
gt; wrong location. If that is the problem I would suggest documenting
gt; what you have see www.mvps.org/dmcritchie/excel/barhopper.htm
gt; and then you can recreate them, as noted you would have to save
gt; your button images.
gt;
gt; Can you give an example of a hyperlink that gets the error message,
gt; and the exact wording of the error message as that is what would
gt; have to be searched on.
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;Ruthquot; gt; wrote in message ...
gt; gt; I recently upgraded one computer to excel 2003. When a hyperlink is created
gt; gt; in Excel 2003 I can not open it in excel 2000 (on my lap top). As message
gt; gt; comes up saying epath or file name may have changed.
gt; gt; --
gt; gt; I.R. Clubbe
gt;
gt;
gt;
Hi Ruth,
Do the other hyperlinked files also not have a pathname, and is it in the
same directory as the other hyperlinked files.
There could be a hyperlink base in the
file, properties, summary
You could be opening all files in these directorites at startup
XLSTART directory (below the directory excel.exe is in)(
alternate startup directory in tools, options, General
I presume Excel will look in your default location (for saving files)
check if that is same on machines tools, options, General
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm
quot;Ruthquot; gt; wrote in message ...
gt; Hi David
gt; Thanks for your reply. Originally the folder with hyperlinks was created in
gt; excel 2000 it worked on the network between two computers. when one computer
gt; broke down I copied the folder onto excel 2003. I can open the hyperlinks
gt; until I get to the final one then I get the following message. 'PZ
gt; Thursday.xls' could not be found. Check the spelling of the file name, and
gt; verify that the file location is correct. If I repeat the Hyperlink on my
gt; second computer in excel 2000 I can then open it and the details on the open
gt; file is as was entered on the excel 2003. Hope you can help thanks. Ruth
gt;
gt; --
gt; I.R. Clubbe
gt;
gt;
gt; quot;David McRitchiequot; wrote:
gt;
gt; gt; One possibility nothing to do with hyperlinks.
gt; gt;
gt; gt; It is not a good idea to copy your toolbars file (.xlb) between different
gt; gt; versions of Excel, that is one possibility. Check the assigned macros
gt; gt; on your menus and toolbar buttons to see if they are referring to the
gt; gt; wrong location. If that is the problem I would suggest documenting
gt; gt; what you have see www.mvps.org/dmcritchie/excel/barhopper.htm
gt; gt; and then you can recreate them, as noted you would have to save
gt; gt; your button images.
gt; gt;
gt; gt; Can you give an example of a hyperlink that gets the error message,
gt; gt; and the exact wording of the error message as that is what would
gt; gt; have to be searched on.
gt; gt; ---
gt; gt; HTH,
gt; gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt; gt;
gt; gt; quot;Ruthquot; gt; wrote in message ...
gt; gt; gt; I recently upgraded one computer to excel 2003. When a hyperlink is created
gt; gt; gt; in Excel 2003 I can not open it in excel 2000 (on my lap top). As message
gt; gt; gt; comes up saying epath or file name may have changed.
gt; gt; gt; --
gt; gt; gt; I.R. Clubbe
gt; gt;
gt; gt;
gt; gt;
Hi Again
I can open 4 sub files when I go to open the 5th there is a differnece in
file name in 2003 file name starts with file:/// in 2000 file name starts \\.
Does this help you at all ??
--
I.R. Clubbequot;David McRitchiequot; wrote:
gt; Hi Ruth,
gt; Do the other hyperlinked files also not have a pathname, and is it in the
gt; same directory as the other hyperlinked files.
gt;
gt; There could be a hyperlink base in the
gt; file, properties, summary
gt; You could be opening all files in these directorites at startup
gt; XLSTART directory (below the directory excel.exe is in)(
gt; alternate startup directory in tools, options, General
gt; I presume Excel will look in your default location (for saving files)
gt; check if that is same on machines tools, options, General
gt;
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;Ruthquot; gt; wrote in message ...
gt; gt; Hi David
gt; gt; Thanks for your reply. Originally the folder with hyperlinks was created in
gt; gt; excel 2000 it worked on the network between two computers. when one computer
gt; gt; broke down I copied the folder onto excel 2003. I can open the hyperlinks
gt; gt; until I get to the final one then I get the following message. 'PZ
gt; gt; Thursday.xls' could not be found. Check the spelling of the file name, and
gt; gt; verify that the file location is correct. If I repeat the Hyperlink on my
gt; gt; second computer in excel 2000 I can then open it and the details on the open
gt; gt; file is as was entered on the excel 2003. Hope you can help thanks. Ruth
gt; gt;
gt; gt; --
gt; gt; I.R. Clubbe
gt; gt;
gt; gt;
gt; gt; quot;David McRitchiequot; wrote:
gt; gt;
gt; gt; gt; One possibility nothing to do with hyperlinks.
gt; gt; gt;
gt; gt; gt; It is not a good idea to copy your toolbars file (.xlb) between different
gt; gt; gt; versions of Excel, that is one possibility. Check the assigned macros
gt; gt; gt; on your menus and toolbar buttons to see if they are referring to the
gt; gt; gt; wrong location. If that is the problem I would suggest documenting
gt; gt; gt; what you have see www.mvps.org/dmcritchie/excel/barhopper.htm
gt; gt; gt; and then you can recreate them, as noted you would have to save
gt; gt; gt; your button images.
gt; gt; gt;
gt; gt; gt; Can you give an example of a hyperlink that gets the error message,
gt; gt; gt; and the exact wording of the error message as that is what would
gt; gt; gt; have to be searched on.
gt; gt; gt; ---
gt; gt; gt; HTH,
gt; gt; gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; gt; gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; gt; gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt; gt; gt;
gt; gt; gt; quot;Ruthquot; gt; wrote in message ...
gt; gt; gt; gt; I recently upgraded one computer to excel 2003. When a hyperlink is created
gt; gt; gt; gt; in Excel 2003 I can not open it in excel 2000 (on my lap top). As message
gt; gt; gt; gt; comes up saying epath or file name may have changed.
gt; gt; gt; gt; --
gt; gt; gt; gt; I.R. Clubbe
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;
So what did you see when you checked each for:
gt; There could be a hyperlink base in the
gt; file, properties, summary
Anyway that type of file reference is usually used on a network,
so I expect you can contact your network administrator for more
information if you can't fix it yourself.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm
quot;Ruthquot; gt; wrote in message ...
gt; Hi Again
gt; I can open 4 sub files when I go to open the 5th there is a differnece in
gt; file name in 2003 file name starts with file:/// in 2000 file name starts \\.
gt; Does this help you at all ??
gt; --
gt; I.R. Clubbe
gt;
gt;
gt; quot;David McRitchiequot; wrote:
gt;
gt; gt; Hi Ruth,
gt; gt; Do the other hyperlinked files also not have a pathname, and is it in the
gt; gt; same directory as the other hyperlinked files.
gt; gt;
gt; gt; There could be a hyperlink base in the
gt; gt; file, properties, summary
gt; gt; You could be opening all files in these directorites at startup
gt; gt; XLSTART directory (below the directory excel.exe is in)(
gt; gt; alternate startup directory in tools, options, General
gt; gt; I presume Excel will look in your default location (for saving files)
gt; gt; check if that is same on machines tools, options, General
gt; gt;
gt; gt; ---
gt; gt; HTH,
gt; gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt; gt;
gt; gt; quot;Ruthquot; gt; wrote in message ...
gt; gt; gt; Hi David
gt; gt; gt; Thanks for your reply. Originally the folder with hyperlinks was created in
gt; gt; gt; excel 2000 it worked on the network between two computers. when one computer
gt; gt; gt; broke down I copied the folder onto excel 2003. I can open the hyperlinks
gt; gt; gt; until I get to the final one then I get the following message. 'PZ
gt; gt; gt; Thursday.xls' could not be found. Check the spelling of the file name, and
gt; gt; gt; verify that the file location is correct. If I repeat the Hyperlink on my
gt; gt; gt; second computer in excel 2000 I can then open it and the details on the open
gt; gt; gt; file is as was entered on the excel 2003. Hope you can help thanks. Ruth
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; I.R. Clubbe
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;David McRitchiequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; One possibility nothing to do with hyperlinks.
gt; gt; gt; gt;
gt; gt; gt; gt; It is not a good idea to copy your toolbars file (.xlb) between different
gt; gt; gt; gt; versions of Excel, that is one possibility. Check the assigned macros
gt; gt; gt; gt; on your menus and toolbar buttons to see if they are referring to the
gt; gt; gt; gt; wrong location. If that is the problem I would suggest documenting
gt; gt; gt; gt; what you have see www.mvps.org/dmcritchie/excel/barhopper.htm
gt; gt; gt; gt; and then you can recreate them, as noted you would have to save
gt; gt; gt; gt; your button images.
gt; gt; gt; gt;
gt; gt; gt; gt; Can you give an example of a hyperlink that gets the error message,
gt; gt; gt; gt; and the exact wording of the error message as that is what would
gt; gt; gt; gt; have to be searched on.
gt; gt; gt; gt; ---
gt; gt; gt; gt; HTH,
gt; gt; gt; gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; gt; gt; gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; gt; gt; gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Ruthquot; gt; wrote in message ...
gt; gt; gt; gt; gt; I recently upgraded one computer to excel 2003. When a hyperlink is created
gt; gt; gt; gt; gt; in Excel 2003 I can not open it in excel 2000 (on my lap top). As message
gt; gt; gt; gt; gt; comes up saying epath or file name may have changed.
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; I.R. Clubbe
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
- Jul 16 Mon 2007 20:38
problem with opening hyperlink in excel 2000
close
全站熱搜
留言列表
發表留言