Welcome to MacForumz.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

File Format Not Valid

 
   Macintosh computer (Home) -> Excel RSS
Related Topics:
Leopard Upgrade -> File Format Not Valid -> every file is - Hoping someone has an idea on this one. I recently upgraded a clients small network (4 comps) to OS X 10.5 The machines were a mix of 10.3 and 10.2 machines. I cloned all machines to ext hard drives and did an erase and install of Leopard on each. ..

File is not a recognizable format. - Hello, I have an Excel (Excel v. X for Mac) that I use almost daily. It contains all of my invoicing history as well as projects that are currently in progress. When I try to open it, it gives the above message. The file will still open, but..

CSV File Format Invalid in Excel? - I recently imported a from a website (Survey Monkey) and it opened in Excel as a .csv file. I saved it and was able to open it later. I spent many hours recoding the data by hand in the and resaved it under a new name, but still..

Excel 2004 - File format no longer supported - Hey all, new to the group. I have an problem that is driving me quite crazy right now. When my users are opening excel docs sent from windows users with Macros, they are getting a Format No Longer error. All users are logged..

Excel in Office X: file saved in strange format - Last July (before applying the Office X 10.1.5 update) I entered some data in Excel, saved the and forgot about it. Now at tax time I find two files saved from that session. One has an .xls extension and 0 kB. The other..
Next:  Excel: Page Breaks change by themselves  
Author Message
Laurie_O16

External


Since: Feb 19, 2008
Posts: 2



(Msg. 1) Posted: Tue Feb 19, 2008 3:04 pm
Post subject: File Format Not Valid
Archived from groups: microsoft>public>mac>office>excel (more info?)

I use the latest version of Microsoft Office for Mac. A few weeks ago I went to open one of my spreadsheets and it said the file format wasn't valid. I finally got it opened and copied the information into a new workbook. I saved the workbook and made sure I could re-open it without problems.

Today I opened that new workbook and it says: file format not valid. I cannot open it to get the information. This only happens with a couple of spreadsheets starting w/the one described above.

Any ideas?

 >> Stay informed about: File Format Not Valid 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3826



(Msg. 2) Posted: Tue Feb 19, 2008 4:53 pm
Post subject: Re: File Format Not Valid [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In article <ee8e0d4.-1.TakeThisOut@webcrossing.caR9absDaxw>,
Laurie_O16.TakeThisOut@officeformac.com wrote:

> I use the latest version of Microsoft Office for Mac. A few weeks ago I went
> to open one of my spreadsheets and it said the file format wasn't valid. I
> finally got it opened and copied the information into a new workbook. I saved
> the workbook and made sure I could re-open it without problems.
>
> Today I opened that new workbook and it says: file format not valid. I cannot
> open it to get the information. This only happens with a couple of
> spreadsheets starting w/the one described above.

Couple of questions:

What version of MacOS? Have you updated recently?

What format are these files in (e.g., xls, .xlsx, etc)

Where are they stored (local HD, network, etc)

Do these files have any distinguishing/common characteristics?

Were these files created by you?

How did you "finally (get) it opened"?

 >> Stay informed about: File Format Not Valid 
Back to top
Login to vote
Laurie_O16

External


Since: Feb 19, 2008
Posts: 2



(Msg. 3) Posted: Tue Feb 19, 2008 4:53 pm
Post subject: Re: File Format Not Valid [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I run version 10.4.11 and it was updated about a couple weeks ago or so.

File formats are .xls

I had them stored on my flash drive but even if I move them to my desktop I cannot open them.

The first file I couldn't open (that I finally got open) was a "to-do" list that I copied the information into the new workbook that I can't open.

Both files were created on my ibook by myself.

I finally got the first file opened because I saved it originally to my desktop. Then I copied it to my flash drive. I then moved the desktop copy to the trash. When the flash drive one wouldn't open I took the other copy out of the trash. When I opened that it says:This file is not in a recognizable format. But, if you click "OK" you can open it.

Since the second workbook was saved on the desktop I did the same thing as the first file by putting it on the flash drive. But with the second, I cannot open it on the flash drive nor on the desktop.
 >> Stay informed about: File Format Not Valid 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3826



(Msg. 4) Posted: Sat Feb 23, 2008 11:12 pm
Post subject: Re: File Format Not Valid [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In article <ee8e0d4.1.RemoveThis@webcrossing.caR9absDaxw>,
Laurie_O16.RemoveThis@officeformac.com wrote:

> I run version 10.4.11 and it was updated about a couple weeks ago or so.
>
> File formats are .xls
>
> I had them stored on my flash drive but even if I move them to my desktop I
> cannot open them.
>
> The first file I couldn't open (that I finally got open) was a "to-do" list
> that I copied the information into the new workbook that I can't open.
>
> Both files were created on my ibook by myself.
>
> I finally got the first file opened because I saved it originally to my
> desktop. Then I copied it to my flash drive. I then moved the desktop copy to
> the trash. When the flash drive one wouldn't open I took the other copy out
> of the trash. When I opened that it says:This file is not in a recognizable
> format. But, if you click "OK" you can open it.
>
> Since the second workbook was saved on the desktop I did the same thing as
> the first file by putting it on the flash drive. But with the second, I
> cannot open it on the flash drive nor on the desktop.

No idea what's going on, sorry. The only thing I can offer is that you
may have some document corruption, in which case the best remedy is
likely to be copying and pasting into a fresh workbook.
 >> Stay informed about: File Format Not Valid 
Back to top
Login to vote
CyberTaz

External


Since: Jul 20, 2005
Posts: 1719



(Msg. 5) Posted: Sun Feb 24, 2008 9:15 am
Post subject: Re: File Format Not Valid [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Just to interject one suggestion -

*Never* open files directly from a USB or attempt to save directly to one -
always copy back & forth from the HD. They're fine for transporting data,
but contrary to their misleading moniker they are *not* drives & shouldn't
be treated as such. Although you can "get away with it" for a while you'll
eventually wind up with corrupt files.

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 2/20/08 5:28 PM, in article ee8e0d4.2 RemoveThis @webcrossing.caR9absDaxw,
"Laurie_O16@officeformac.com" <Laurie_O16 RemoveThis @officeformac.com> wrote:

> Any ideas yet?
 >> Stay informed about: File Format Not Valid 
Back to top
Login to vote
Hugh Mackenzie

External


Since: Apr 01, 2008
Posts: 1



(Msg. 6) Posted: Tue Apr 01, 2008 5:15 pm
Post subject: Re: File Format Not Valid [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

> I use the latest version of Microsoft Office for Mac. A few weeks ago I went to open one of my spreadsheets and it said the file format wasn't valid. I finally got it opened and copied the information into a new workbook. I saved the workbook and made sure I could re-open it without problems.
>
> Today I opened that new workbook and it says: file format not valid. I cannot open it to get the information. This only happens with a couple of spreadsheets starting w/the one described above.
>
> Any ideas?

I'm having exactly the same problem. I work away on a file that I have created, saved on my hard drive, save it and close it. But when I try to open the file, I get a message saying that the file format is not valid. Luckily I'm using Leopard 10.5 and Time Machine, so I can usually go far enough back to get a version that will work, but I've lost the work I did in the meantime. It doesn't happen all the time. Only occasionally. Before the first upgrade came out, I was having problems saving large files that have pivot tables. Excel 2008 simply refused to save these large files. I haven't tested to see if the upgrade fixed this problem, but the problem I'm posting about here didn't start happening until after the upgrade was installed. I'm inclined to stop using Excel 2008 and stick to 2004 until these problems are fixed.
 >> Stay informed about: File Format Not Valid 
Back to top
Login to vote
CyberTaz

External


Since: Jul 20, 2005
Posts: 1719



(Msg. 7) Posted: Wed Apr 02, 2008 1:59 am
Post subject: Re: File Format Not Valid [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I'm afraid I don't have an answer for you, but I can say that since you
don't even mention the use of a USB flash drive your problem is *not*
"exactly the same" - in fact, it's not even related.

Even if it were, hijacking threads that have been cold for a month or more
is not the best way to call attention to your need. It sounds like a serious
matter so I'd suggest that you submit it as a *new* post giving all
specifics about your OS version & type of Mac as well as any other details
about the files involved.

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 4/1/08 9:15 PM, in article ee8e0d4.5.RemoveThis@webcrossing.caR9absDaxw, "Hugh
Mackenzie" <hughmack.RemoveThis@mac.com> wrote:

>> I use the latest version of Microsoft Office for Mac. A few weeks ago I went
>> to open one of my spreadsheets and it said the file format wasn't valid. I
>> finally got it opened and copied the information into a new workbook. I saved
>> the workbook and made sure I could re-open it without problems.
>>
>> Today I opened that new workbook and it says: file format not valid. I cannot
>> open it to get the information. This only happens with a couple of
>> spreadsheets starting w/the one described above.
>>
>> Any ideas?
>
> I'm having exactly the same problem. I work away on a file that I have
> created, saved on my hard drive, save it and close it. But when I try to open
> the file, I get a message saying that the file format is not valid. Luckily
> I'm using Leopard 10.5 and Time Machine, so I can usually go far enough back
> to get a version that will work, but I've lost the work I did in the meantime.
> It doesn't happen all the time. Only occasionally. Before the first upgrade
> came out, I was having problems saving large files that have pivot tables.
> Excel 2008 simply refused to save these large files. I haven't tested to see
> if the upgrade fixed this problem, but the problem I'm posting about here
> didn't start happening until after the upgrade was installed. I'm inclined to
> stop using Excel 2008 and stick to 2004 until these problems are fixed.
 >> Stay informed about: File Format Not Valid 
Back to top
Login to vote
Display posts from previous:   
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]