#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Error

Hello I have been working with a spread sheet and I saved and closed it. Now
when I try to open it and it says "Format unrecognized"

The spread sheet has abotu 70 Marcos and 14 worksheats. Please help me...

Thanks,
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Error

Perhaps try the "Open and repair" option (in xl2003) on a copy of your file.

Sequence:
File Save as .. (give it a back-up name)
Close the file
File Open
Navigate to and select the "back-up" file in the "Open" dialog
Click on the tiny dropdown to the right of "Open" button
choose "Open and Repair.."


Good luck
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Randaddyz" wrote:
Hello I have been working with a spread sheet and I saved and closed it. Now
when I try to open it and it says "Format unrecognized"

The spread sheet has abotu 70 Marcos and 14 worksheats. Please help me...

Thanks,

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Error

i just tried and it does the same thing. Format Not Recognized and when I
click ok it is a whole bunch of garbley gook. I also tried it on 2 other
workstations. Any other ideas. This is spread sheet is really important.

Randy

"Max" wrote:

Perhaps try the "Open and repair" option (in xl2003) on a copy of your file.

Sequence:
File Save as .. (give it a back-up name)
Close the file
File Open
Navigate to and select the "back-up" file in the "Open" dialog
Click on the tiny dropdown to the right of "Open" button
choose "Open and Repair.."


Good luck
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Randaddyz" wrote:
Hello I have been working with a spread sheet and I saved and closed it. Now
when I try to open it and it says "Format unrecognized"

The spread sheet has abotu 70 Marcos and 14 worksheats. Please help me...

Thanks,

  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Error

Sorry that didn't help. Other than hoping that you do have a fairly recent
back-up copy to recover it, I'm out of ideas.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Error

"Randaddyz" wrote:

Hello I have been working with a spread sheet and I saved and closed it. Now
when I try to open it and it says "Format unrecognized"

The spread sheet has abotu 70 Marcos and 14 worksheats. Please help me...

Thanks,


Assuming you've exhausted the few options suggested in the Microsoft KB:
I've run into many situations in the past that called for a 3rd party Office
file recovery tool. I've had extremely good results with this approach and
was able to justify the cost when "VIP's" and important projects were
involved. Consider it...


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Error

Hi,

I tried a third party recovery with no luck. We do have a backup but because
our CFO was working from home and then brought it in our backup of this file
is corrupt and looked at his home comp and samething. I guess he/we are SOL.

"knightrd" wrote:

"Randaddyz" wrote:

Hello I have been working with a spread sheet and I saved and closed it. Now
when I try to open it and it says "Format unrecognized"

The spread sheet has abotu 70 Marcos and 14 worksheats. Please help me...

Thanks,


Assuming you've exhausted the few options suggested in the Microsoft KB:
I've run into many situations in the past that called for a 3rd party Office
file recovery tool. I've had extremely good results with this approach and
was able to justify the cost when "VIP's" and important projects were
involved. Consider it...

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Error

Hi,

I tried a third party recovery with no luck. We do have a backup but because
our CFO was working from home and then brought it in our backup of this file
is corrupt and looked at his home comp and samething. I guess he/we are SOL.

"knightrd" wrote:

"Randaddyz" wrote:

Hello I have been working with a spread sheet and I saved and closed it. Now
when I try to open it and it says "Format unrecognized"

The spread sheet has abotu 70 Marcos and 14 worksheats. Please help me...

Thanks,


Assuming you've exhausted the few options suggested in the Microsoft KB:
I've run into many situations in the past that called for a 3rd party Office
file recovery tool. I've had extremely good results with this approach and
was able to justify the cost when "VIP's" and important projects were
involved. Consider it...

  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Error

Hi,

I tried a third party recovery with no luck. We do have a backup but because
our CFO was working from home and then brought it in our backup of this file
is corrupt and looked at his home comp and samething. I guess he/we are SOL.

"knightrd" wrote:

"Randaddyz" wrote:

Hello I have been working with a spread sheet and I saved and closed it. Now
when I try to open it and it says "Format unrecognized"

The spread sheet has abotu 70 Marcos and 14 worksheats. Please help me...

Thanks,


Assuming you've exhausted the few options suggested in the Microsoft KB:
I've run into many situations in the past that called for a 3rd party Office
file recovery tool. I've had extremely good results with this approach and
was able to justify the cost when "VIP's" and important projects were
involved. Consider it...

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error: "Excel encountered an error and had to remove some formatti Carl Excel Discussion (Misc queries) 0 September 18th 06 06:39 PM
Counting instances of found text (Excel error? Or user error?) S Davis Excel Worksheet Functions 5 September 12th 06 04:52 PM
I have Error 1919 Error Configuring ODBC dataSource Database Texanna1 Excel Discussion (Misc queries) 1 September 12th 06 06:35 AM
Excel 2003 Macro Error - Runtime error 1004 Cow Excel Discussion (Misc queries) 2 June 7th 05 01:40 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"