Excel 2003 looses document properties

[donat]

We have an Excel list where one colum contains hyperlinks (list of
documents).

If the list exceeds about 1500 lines with hyperlinks then Excel Workbook
looses all document properties (builtin properties like title, author, ...
and custom properties) during save!
Is there somewhere a documented limit or is this a (known) bug?

regards,
donat

 

[Dave Peterson]

I've never been a fan of putting lots of Insert|Hyperlink style hyperlinks into
a workbook/worksheet--or lots of controls from the control toolbox toolbar for
that matter.

When I know I'm gonna end up with a lot of hyperlinks, I'll use the =hyperlink()
worksheet function.

With the path in A1 like:
C:\my documents\excel\
(with the trailing backslash)

And the name of the file in A2:A1500, I'll use a formula like this in B2 (and
drag down):

=hyperlink("file:////"&$a$1&$a2,"Click me")

 

[donat]

Thanks Dave,
I will check this approach, and provide the result.
But this needs conversion (macro) of the list, which actually is a report
from a db.

donat

 

[donat]

No limitations with =hyperlink() function and as a positive side effect the
file size shrinks by 50%.
I did the conversion by a simple macro, because I have to repeat it
periodically.

donat

 

[Dave Peterson]

I wasn't sure what you meant by conversion of the list--what should be retrieved
from where.

But glad it worked for you.