Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/102013

From BetaArchive Wiki

Microsoft Knowledge Base

Excel Err Msg: Cannot Define View. Too Many Hidden Rows...

Last reviewed: September 12, 1996
Article ID: Q102013

The information in this article applies to:

  • Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0, 5.0c
  • Microsoft Excel for the Macintosh, version 4.0
  • Microsoft Excel for Windows NT, version 5.0

SYMPTOMS

In Microsoft Excel, when you attempt to create a view with a file that contains many discontiguous hidden rows or columns, you may receive the error message:

   Cannot define view. Too many hidden rows or columns are selected.

CAUSE

When you create a view in Microsoft Excel, View Manager establishes a defined name referencing all discontiguous hidden rows and columns. The reference for a defined name has a limit of 255 characters. When you create a view with many discontiguous hidden ranges, you will receive the error if the number of characters needed to store the reference for the hidden ranges on the sheet exceeds 255 characters.

The error is more likely to occur when the sheet contains many small hidden ranges than if it contains a few very large hidden ranges because more characters are required to store the reference to many small hidden ranges than a few very large hidden ranges.

In general, a view can hold about 25 hidden ranges. This will fluctuate with the location of cell ranges because it requires more characters to save references to cell ranges in higher row numbered areas of the sheet than in lower row numbered areas.

STATUS

This behavior is by design.

REFERENCES

User's Guide 1, pages 255-256 User's Guide 2, pages 195-202


KBCategory: kberrmsg

KBSubcategory:

Additional reference words: 4.00 4.00a addin hide views.xla



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.