G
Gail
We are hitting the limits of the available characters in
the formulas of our application. We therefore cannot use
UNC paths for links, instead using the drive designator
e.g. G\ak\shared02.... to link to source data. Although
the sheets are protected, there are occassions where for
some reason the paths, which are hard coded are
converting to the absolute path address e.g.
telecom.tcnz.net. This of course, breaks the links in the
application. We have moved the source data as close as
possible to each workbook and reduced formula length by
setting up extract files using 'values' linked to the
formula ridden source data sheets.
the formulas of our application. We therefore cannot use
UNC paths for links, instead using the drive designator
e.g. G\ak\shared02.... to link to source data. Although
the sheets are protected, there are occassions where for
some reason the paths, which are hard coded are
converting to the absolute path address e.g.
telecom.tcnz.net. This of course, breaks the links in the
application. We have moved the source data as close as
possible to each workbook and reduced formula length by
setting up extract files using 'values' linked to the
formula ridden source data sheets.