What is the limit of ...

[Ergun]

Hi all...have two questions

(1) What is the limit of number of User Defined cells in
an object?

(2) What is the limit of number of cell references in a
page/document. If there is no limit at what point document
becomes too slow to be practical?

Cheers

Ergun

 

[Mark Nelson [MS]]

I do not believe there is a hard limit for either of those items. Your only
concern would be performance. A sensible performance limit is very
difficult to determine. It depends on what you are doing.

Obviously the more references overall, the worse the performance, but you
can probably have a very large number of references. An important point
would be to minimize the number of "cross-sheet" references, those that
point to a cell in a different shape or to the page. If you use a value
from another shape multiple times in a shape, it would be better to add a
User Defined cell with a single reference to the other shape. Then
everybody can use the local reference.

Note that there is a limit to what we call reference depth or reference
chaining. Consider formulas like this:
User.Row_10 = User.Row_9
User.Row_9 = User.Row_8
User.Row_8 = User.Row_7
User.Row_7 = User.Row_6
and so on...

Visio will only follow up to 10 references to get an actual value for the
cell.