A
Adagioblue
After the Office 12.0.1 update, all my hyperlinks are gone. I have 4 Excel
workbooks that I use daily that include a ton of hyperlinks as well as
numeric formulas. Rather than removing the 12.0.1 update, I decided to
rebuild the workbooks in new 12.0.1 docs. After Copy/Pasting everything over
to the new docs, I realized that none of the formulas had been transferred,
only the values. The only way to transfer the formulas is to open the cell
and copy from the formula bar, then paste to the new doc.
I have two hard drives on this computer. Excel 2008 12.0.1 is on the boot
drive and Excel 2004 11.3.7 is on the secondary drive. The docs had already
been updated and used successfully in Excel 2008, and worked fine until the
12.0.1 update. It wasn't until AFTER the update that I had to revert back to
2004 to use the docs. The transfers were done with both versions open at the
same time. I'm using Leopard 10.5.2.
workbooks that I use daily that include a ton of hyperlinks as well as
numeric formulas. Rather than removing the 12.0.1 update, I decided to
rebuild the workbooks in new 12.0.1 docs. After Copy/Pasting everything over
to the new docs, I realized that none of the formulas had been transferred,
only the values. The only way to transfer the formulas is to open the cell
and copy from the formula bar, then paste to the new doc.
I have two hard drives on this computer. Excel 2008 12.0.1 is on the boot
drive and Excel 2004 11.3.7 is on the secondary drive. The docs had already
been updated and used successfully in Excel 2008, and worked fine until the
12.0.1 update. It wasn't until AFTER the update that I had to revert back to
2004 to use the docs. The transfers were done with both versions open at the
same time. I'm using Leopard 10.5.2.