Re: Spell checking

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi John

Thanks for the reply. It is a new spreadsheet in Office for Mac 2008 I purchased along with my MacBook 3 months ago. I did try as you suggested but still the problem exists.

I'll just have to keep trying and also improve my spelling.

PBM

Sorry, I cannot produce that error in Excel 2008.

Are you sure you have applied all the most recent updates to Excel?

Somehow you are triggering an error message telling you that a "Text" string
cannot exceed 255 characters. The only place I can think of that that could
occur is if the string is being returned or processed by a Macro. There are
times when XLM would not like a text string that exceeded 255 characters.

Would this be a VERY old spreadsheet? If it were in Excel 7 format (pre
Excel 98) there is a hard limit of 255 characters in a cell... Try saving
it as .XLSX (and remove the Compatibility Options).

Sorry, we only do email replies to paying customers. The whole intent of
these forums is that the volunteers need donate their time only once per
question, then a large number of people with the same question can benefit
from that single post.

Hope this helps


On 27/10/09 1:45 PM, in article 59b7f619.-1@xxxxxxxxxxxxxxxxxxxxxxx,
"PBM@xxxxxxxxxxxxxxxx" wrote:

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When I select ABC-Sppelling to do a spell check I receive the message:

"The text string is too long - A text string must be between 1 and 255
characters. Reduce the number of characters or delete the entry".

I have checked all options in the Excel Preferences with no success. I noticed
under Authoring there is no Proofing Tools or Spelling /Grammar icon, as there
is in Word Prefernces.

Can you please assist me?


--

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:john@xxxxxxxxxxx



.

Relevant Pages

  • RE: Pasting records from Excel into Access2000
    ... characters into at least one cell in the spreadsheet or else has reordered ... While Excel doesn't enforce field sizes, ... If this is not the case, then check your "Pasting Errors" table. ...
    (microsoft.public.access.externaldata)
  • Re: Save as HTML - Page setup information missing
    ... I made an Excel worksheet with a header and footer. ... We want to use HTML to ... create the spreadsheet i.e when you save the spreadsheet as HTML, ... is, in MAC, Excel does not pass this page setup information to HTML. ...
    (microsoft.public.mac.office.excel)
  • Help merging worksheets with more than 255 characters...
    ... I am working on a project which requires mail merging an Excel ... spreadsheet with several fields that contain more than 255 characters. ...
    (microsoft.public.excel)
  • Re: Spell checking
    ... I believe the OP means that it's a new spreadsheet s/he created using a copy ... characters in a cell before it hits a limit. ... It is a new spreadsheet in Office for Mac 2008 I ... Are you sure you have applied all the most recent updates to Excel? ...
    (microsoft.public.mac.office.excel)
  • Re: Can import the data from excel
    ... Go ahead and change your field size to 255 characters if it helps, ... There are many reasons why you may still run into trouble trying to import the spreadsheet data. ... Your table has a foreign key field, and someone typed a non-matching value in the Excel cell. ...
    (microsoft.public.access.tablesdbdesign)