How to rename Excel Sheet with more characters?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have AccPacc exporting sheets to excel 2000 which worked ok before, but
when i try to export to excel 2003, it gives me an error because you cannot
put more than 20 or so characters in the Sheet name (Accpacc Exports names
the sheets with 20-30 characters.)

Any method to allow for more characters when renaming the sheets in excel
2003?
 
You get 31 characters for a sheet name in xl2003 (through xl95???).

Maybe it's the name or the characters in the name causing trouble????
 
When i checked the Accpac worksheets exported thru xl2000, the name was over
50 characters, sorry for the misunderstanding. I just want to know if there
is a patch or something that will increase that limit ?
 
I don't think so.
When i checked the Accpac worksheets exported thru xl2000, the name was over
50 characters, sorry for the misunderstanding. I just want to know if there
is a patch or something that will increase that limit ?
Click to expand...
 
To be clear. I don't know of a patch for excel.

Maybe there's one for AccPacc??????
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel text export limit - 1024 per line (not cell), workaround? 11
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How can I copy more than 255 characters in a cell without truncati 1
Batch renaming of worksheets 1
Show or Hide control characters in a cell (using Excel 2007)... 0
Autocopy the first cell with more than 30 characters to a different sheet? 1
Character Counting 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Back
Top