Max size (bytes) of data stored in a workbook name?

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
For Excel 97, Help, Workbook let me see the following:

"Guidelines for naming workbooks

To make it easier to find your workbooks, you can use long, descriptive file names. The complete path to the file, including drive letter, server name, folder path, file name,and a three-character file name extension, can contain up to 218 characters. File names cannot include any of the following characters: forward slash ( / ), backslash ( \ ), greater-than sign ( > ), less-than sign ( < ), asterisk ( * ), question mark ( ? ), quotation mark ( " ), pipe symbol ( | ), colon ( : ), or semicolon ( ; ).

If you work with other programs that do not support long file names, you should limit file names to eight characters."
 
L

Legacy 98055

Guest
Thanks Ralph.

I should have been more descriptive. If, for example, I was storing an array in a Workbook.Name object. The total number of bytes allowed. As in Len(Variable). I did find an answer.

Excel 97 and 2000 256 max Columns with a max total of 5561 elements.

In XP and 2003 you are limited only by the amount of memory.

Thanks,

Tom
 

Watch MrExcel Video

Forum statistics

Threads
1,118,913
Messages
5,575,005
Members
412,634
Latest member
Sumanmathew
Top