Excel 2008 hyperlinks won’t save on .xlsxformat, but will save in xls format.

[tombleweed]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel xcel 2008 hyperlinks won't save on .xlsx format, but will save in xls format.

After the workbook is saved and reopened the hyperlink give the error message "Reference is not valid".

I have cleared all links and hyperlinks and replaced the hyperlinks a number of time with the same results.

 

[John McGhie]

Make sure you have applied all the updates top Office. I think this one was
solved in a service pack.

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
xcel 2008 hyperlinks won't save on .xlsx format, but will save in xls format.

After the workbook is saved and reopened the hyperlink give the error message
"Reference is not valid".

I have cleared all links and hyperlinks and replaced the hyperlinks a number
of time with the same results.

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[tombleweed]

Make sure you have applied all the updates top Office. I think this one was

 

[tombleweed]

I have finally determined the problem with saving Hyperlinks.

If there is a space in the worksheet name tab, it will not save the hyperlink when you save it in .xlsx format, but will in .xls format.

 

[John McGhie]

If you did not re-apply all the updates first, it wouldn't make any
difference.

If you did not run the Remove Office tool first, it would make it worse!



--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[CyberTaz]

It sounds like you're going one step too far ‹ or not far enough ‹ when
creating the hyperlink... Whether or not there is a space in the name of the
sheet is irrelevant

In the Insert> Hyperlink dialog I believe that in addition to specifying the
target file you may also be clicking the 'Locate' button & selecting from
the Sheet Names listed there. The Locate option is for hyperlinking to a
specific Named Range in the target file. True, spaces are illegal in Range
Names, but the actual reason you're getting the message is because there is
no Range in the target file by that name. IOW, you'll get the same error
message even if the specified sheet has no space in it's name.

Select any one or more cells on the sheet, assign a name to that range, then
link to it ‹ see if the message doesn't cease.

The word "anchor" is a bit deceptive because the Locate dialog does permit
selecting only a sheet name from the Cell Reference list & sheet names are
allowed to include spaces, but you need to go farther. It's expected that
after you select the sheet (based on its name) that you also specify the
reference of a cell or range *on* that sheet. Even if the sheet name has no
spaces, though, the hyperlink will not cause the target file to open to the
specified sheet if you include only the sheet name. You need to identify the
specific cell, range of cells, or Defined Name within the target workbook.

IMHO, that is a bug & should be addressed in Office 2011 if not sooner...
There has to be a clearer, more elegant way to handle the matter.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[tombleweed]

To CyberTaz: Maybe a detail I left out was that I'm wanting to Hyperlink to another worksheet in the same workbook.

I can do it by creating a named range in the desired worksheet of the same book as you mention in your 2nd paragraph, or without a space in the worksheet tab name by using the Anchor - Locate and Cell Reference which automatically adds A1 for a cell reference. If there are spaces in the worksheet name using Anchor-Locate it works until it is saved and reopened.

I can also create a hyperlink to another workbook successfully via using Select and then Anchor-Locate-Cell Reference, but the same technique does not work if I Select my same workbook where I'm creating the hyperlink.

Tom
retired softhead