Issue 14205 - Limit on the number of external spreadsheet references
Summary: Limit on the number of external spreadsheet references
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2003-05-07 15:37 UTC by chameenz
Modified: 2013-02-07 22:40 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description chameenz 2003-05-07 15:37:19 UTC
I created a spreadsheet that referenced ALOT of external sheets. Enough, in 
fact, that I exceeded the program limit of 256 sheets. I was not aware of the 
limit, and received the #NAME? error message throughout most of the document. 
In researching the problem I found that...

"A Calc doc is limited to 256 sheets. Each referenced external sheet creates a 
hidden sheet in the doc, containing the cached data of the external sheet. If 
the total count of your visible and hidden sheets reaches 256, no more links to 
other files are possible. You can check the number of your sheets in the status 

It seems that there is no warning message to indicate this to the user.
Is it possible to add this so that the user does not think it is a bug ?
Comment 1 frank 2003-05-07 16:33:11 UTC
Hi Bettina,

1 4 u

Comment 2 ace_dent 2008-05-16 02:42:02 UTC Issue Tracker - Feedback Request.

The Issue you raised has the status 'New' pending further action, but has not
been updated within the last 4 years. Please consider re-testing with one of the
latest versions of OOo, as the problem(s) may have already been addressed.
Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
Comment 3 gnustavo 2008-05-25 21:34:56 UTC
I confirm that this problem still happens in OOo 2.4.0.
Comment 4 gnustavo 2008-05-25 21:37:10 UTC
I would also suggest that the fact that the user gets no warning when she
reaches the limit be considered a bug. The enhancement would be to increase the
Comment 5 bettina.haberer 2010-05-21 14:54:52 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".