ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Hyperlinks break when synching from Pocket Excel (https://www.excelbanter.com/links-linking-excel/91704-hyperlinks-break-when-synching-pocket-excel.html)

rev_cletus

Hyperlinks break when synching from Pocket Excel
 
I'm using a very simple Excel spreadsheet as a checkbook, and have taken to
linking entries for cleared checks to their images, obtained from my bank,
which I keep in a folder adjacent to the one the spreadsheet's located in. I
keep a copy of the spreadsheet and the images, in the same file structure,
on my Axim handheld and synchronize the files with MS ActiveSynch.

I find, however, when I make changes to the file on the handheld and those
are subsequently synched with the file on my PC, that the hyperlinks are
broken. Made sense, I figured, as the absolute path to the images is a wee
bit different on the handheld (the hyperlinks, of course, referenced a path
from C:// on the PC, which isn't the same as the structure on the PDA);
however, adjusting the absolute path via the Files | Properties | Hyperlink
base setting in Excel, on the PC, seems to have no effect. I can reset all
the links to the images on the PC, synchronize to the handheld, then go to
the handheld and see the links are made; but when I make changes to the
checkbook on the handheld and they're subsequently synched, they're broken
again.

Not a big deal...but it would be good to know if this is something that can
be done!

Thanks...

rev_c






All times are GMT +1. The time now is 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com