PC Review


Reply
Thread Tools Rate Thread

What causes an "Invalid Format" error in Excel 2002 to crash the f

 
 
jfarley@rfm.com
Guest
Posts: n/a
 
      25th Nov 2009
My files crash over and over again. It is a relatively large file. The
error message is "invalid format", but it does not say what format is
invalid. My version of Excel appears to be 2002, SP3. The error occurs when
I go to save the file.

HELP!

Jim Farley
 
Reply With Quote
 
 
 
 
trip_to_tokyo
Guest
Posts: n/a
 
      26th Nov 2009
Try and save a smaller version of the file.

What you need to do is to try and isolate where the error is occurring.

To give to a simple example.

Let us assume that you spreadsheet covers only cells A 1 to E 6 inclusive.

Copy of smaller subset of that data (say cells A 1 to C3) off to another
Workbook and then save that. Does the smaller subset save OK? If it does the
problem is probably not in that data.

This could be a slow and laborious process, I admit, but you should
(eventually!) be able to isolate the offending cell(s).

If my comments have helped please hit Yes.

Thanks!



"(E-Mail Removed)" wrote:

> My files crash over and over again. It is a relatively large file. The
> error message is "invalid format", but it does not say what format is
> invalid. My version of Excel appears to be 2002, SP3. The error occurs when
> I go to save the file.
>
> HELP!
>
> Jim Farley

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
When Using Format(Now(), "yyyymmmddhhmm") get wrong number of arguments or invalid property assignment Error Connie Microsoft Excel Programming 2 8th Nov 2006 08:30 AM
" Invalid Argument" error (# 3001) - Conversion Access 97 to 2002 =?Utf-8?B?ZnJlZF95X09oaW8=?= Microsoft Access 2 29th Jun 2006 04:41 AM
Excel XP problem - "Old format or invalid type" da20 Microsoft C# .NET 0 31st Mar 2005 12:26 AM
system error message "enpoint format is invalid" =?Utf-8?B?dHNyZWVzZQ==?= Windows XP Help 1 6th Jan 2004 12:11 AM
Can't start Win XP, "system error endpoint format is invalid" Alex Windows XP Accessibility 1 15th Oct 2003 07:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:18 PM.