Question about Microsoft EXCEL 2004 for Mac

18 Answers

Excel file will not open

Hi. My team at work has been working on this Excel file, which is full of macro commands and links to other documents. It currently lives on our company 'intranet' or server, where most of company documents and files live for others to access.
This morning, it was discovered that the file will no longer open. 
Typically, when opening, the macro-enabling window appears. Usually I choose Enable Macros. And then a window regarding the links to other workbooks appears, for which I usually choose Ignore Links... and then the file would open. 
But now, regardless of whether I enable or disable macros, or if I ignore the links or try to update them, the excel file refuses to open. When disabling macros, a message window appears, stating that 'This workbook contains a type of macro (MS Excel 4.0 macro) that cannot be disabled. There may be viruses in these macros'. I'm not sure if this is the problem or not.
Anyway, what follows is a portion of the error report that is returned after the 'The application Excel quit unexpectedly' message window appears: ----- OS Version:     10.4.11 (Build 8S2167) Report Version: 4
Command: Microsoft Excel Path:    /Applications/Microsoft Office 2004/Microsoft Excel Parent:  WindowServer [59] Rosetta: Yes
Version: 11.5.0 (11.5.0 (080428), © 2004 Microsoft Corporation.  All rights reserved.)
PID:    380 Thread: Unknown
Exception:  EXC_BAD_ACCESS (0x0001) Codes:      KERN_PROTECTION_FAILURE (0x0002) at 0x00000018
Thread 0: 0   LaunchCFMApp 0xb80a564f 0xb8000000 + 677455 1   LaunchCFMApp 0xb809fb15 0xb8000000 + 654101 2   LaunchCFMApp 0xb80bd72e 0xb8000000 + 775982 3   LaunchCFMApp 0xb811e403 spin_lock_wrapper + 1985
Thread 1: 0   LaunchCFMApp 0xb822fa6b strchr + 72 1   LaunchCFMApp 0xb81cb487 pthread_cond_wait + 3114 2   LaunchCFMApp 0xb816765e catch_exception_raise_state_identity + 318 3   LaunchCFMApp 0xb8166b9a CallPPCFunctionAtAddressInt + 177124 4   LaunchCFMApp 0xb8166a91 CallPPCFunctionAtAddressInt + 176859 5   LaunchCFMApp 0xb816775c catch_exception_raise_state_identity + 572 6   LaunchCFMApp 0xb8200c00 pthread_create + 1124
Thread 2: 0   LaunchCFMApp 0xb813446b spin_lock_wrapper + 92201 1   LaunchCFMApp 0xb815fa34 CallPPCFunctionAtAddressInt + 148094 2   LaunchCFMApp 0xb8162601 CallPPCFunctionAtAddressInt + 159307 3   LaunchCFMApp 0xb80c805c 0xb8000000 + 819292
Thread 3: 0   LaunchCFMApp 0xb813431a spin_lock_wrapper + 91864 1   LaunchCFMApp 0xb814d4b8 CallPPCFunctionAtAddressInt + 72962 2   LaunchCFMApp 0xb80a626f 0xb8000000 + 680559 3   LaunchCFMApp 0xb809fb15 0xb8000000 + 654101 4   LaunchCFMApp 0xb80bd72e 0xb8000000 + 775982 5   LaunchCFMApp 0xb811eb4e spin_lock_wrapper + 3852
Unknown thread crashed with i386 Thread State: eax: 0x00000018  ebx: 0xb80a5628  ecx:0x00000000  edx: 0x00000003 edi: 0x00000018  esi: 0x80d03990  ebp:0xb7fff9f8  esp: 0xb7fff9c0  ss: 0x0000001f  efl: 0x00010206  eip:0xb80a564f   cs: 0x00000017  ds: 0x0000001f   es: 0x0000001f   fs:0x00000000   gs: 0x00000037 -----
Please help! Our team has been working on this document for months, and it would be a shame if it is lost.

Posted by on

  • 11 more comments 
  • melissa_rama Jan 26, 2009

    Hi. My team at work has been working on this Excel file, which is full of macro commands and links to other documents. It currently lives on our company 'intranet' or server, where most of company documents and files live for others to access.

    This morning, it was discovered that the file will no longer open.

    Typically, when opening, the macro-enabling window appears. Usually I choose Enable Macros. And then a window regarding the links to other workbooks appears, for which I usually choose Ignore Links... and then the file would open.

    But now, regardless of whether I enable or disable macros, or if I ignore the links or try to update them, the excel file refuses to open. When disabling macros, a message window appears, stating that 'This workbook contains a type of macro (MS Excel 4.0 macro) that cannot be disabled. There may be viruses in these macros'. I'm not sure if this is the problem or not.

    Anyway, what follows is a portion of the error report that is returned after the 'The application Excel quit unexpectedly' message window appears:
    ----- OS Version: 10.4.11 (Build 8S2167)
    Report Version: 4
    Command: Microsoft Excel Path: /Applications/Microsoft Office 2004/Microsoft Excel Parent: WindowServer [59] Rosetta: Yes
    Version: 11.5.0 (11.5.0 (080428), © 2004 Microsoft Corporation. All rights reserved.)
    PID: 380 Thread: Unknown
    Exception: EXC_BAD_ACCESS (0x0001) Codes: KERN_PROTECTION_FAILURE (0x0002) at 0x00000018
    Thread 0: 0 LaunchCFMApp 0xb80a564f 0xb8000000 + 677455 1 LaunchCFMApp 0xb809fb15 0xb8000000 + 654101 2 LaunchCFMApp 0xb80bd72e 0xb8000000 + 775982 3 LaunchCFMApp 0xb811e403 spin_lock_wrapper + 1985
    Thread 1: 0 LaunchCFMApp 0xb822fa6b strchr + 72 1 LaunchCFMApp 0xb81cb487 pthread_cond_wait + 3114 2 LaunchCFMApp 0xb816765e catch_exception_raise_state_identity + 318 3 LaunchCFMApp 0xb8166b9a CallPPCFunctionAtAddressInt + 177124 4 LaunchCFMApp 0xb8166a91 CallPPCFunctionAtAddressInt + 176859 5 LaunchCFMApp 0xb816775c catch_exception_raise_state_identity + 572 6 LaunchCFMApp 0xb8200c00 pthread_create + 1124
    Thread 2: 0 LaunchCFMApp 0xb813446b spin_lock_wrapper + 92201 1 LaunchCFMApp 0xb815fa34 CallPPCFunctionAtAddressInt + 148094 2 LaunchCFMApp 0xb8162601 CallPPCFunctionAtAddressInt + 159307 3 LaunchCFMApp 0xb80c805c 0xb8000000 + 819292
    Thread 3: 0 LaunchCFMApp 0xb813431a spin_lock_wrapper + 91864 1 LaunchCFMApp 0xb814d4b8 CallPPCFunctionAtAddressInt + 72962 2 LaunchCFMApp 0xb80a626f 0xb8000000 + 680559 3 LaunchCFMApp 0xb809fb15 0xb8000000 + 654101 4 LaunchCFMApp 0xb80bd72e 0xb8000000 + 775982 5 LaunchCFMApp 0xb811eb4e spin_lock_wrapper + 3852
    Unknown thread crashed with i386 Thread State: eax: 0x00000018 ebx: 0xb80a5628 ecx:0x00000000 edx: 0x00000003 edi: 0x00000018 esi: 0x80d03990 ebp:0xb7fff9f8 esp: 0xb7fff9c0 ss: 0x0000001f efl: 0x00010206 eip:0xb80a564f cs: 0x00000017 ds: 0x0000001f es: 0x0000001f fs:0x00000000 gs: 0x00000037 -----
    Please help! I understand that there is recovery software out there, but is there a way to 'recover' this file without software? And how can this be prevented in the future (aside from creating a backup file)?

  • melissa_rama Jan 26, 2009

    I've had other members of the team try to open the file on their computers, but it doesn't work. Or copying the file from the server onto our desktop, but that doesn't work either. 


    Luckily we do have earlier version of this document saved. A lot of work will need to be redone though.


    I just wish I knew what happened so that it can be prevented in the future... it's just so frustrating...

  • melissa_rama Jan 26, 2009

    I've had other members of the team try to open the file on their computers, but it doesn't work. Or copying the file from the server onto our desktop, but that doesn't work either.

    Luckily we do have earlier version of this document saved. A lot of work will need to be redone though.

    I just wish I knew what happened so that it can be prevented in the future... it's just so frustrating...

  • melissa_rama Jan 26, 2009

    If it is a virus, then I'm even more confused. Wouldn't a virus need to introduced from an outside source? No? I don't understand how a document can all of a sudden catch a virus... 

  • melissa_rama Jan 26, 2009

    machadojr_fe
    Rank: Guru
    Rating: 86%, 69 votes
    please open excel then from within excel click open and then find the file and click the black arrow next to open and select open and repair. Please let me know what happens when you try this.

    --- I wasn't able to do this because there is no 'open and repair' option. The options I was given was opening original, copy or read-only.

  • melissa_rama Jan 26, 2009

    MNfisherman
    Rank: Wiz
    Rating: 83%, 47 votes

    To manually repair a file
    On the File menu, click Open.
    In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
    Click Open and Repair, and then choose which method you want to use to recover your workbook.
    OTHER WAYS TO OPEN THE FILE

    Start Excel and open a blank workbook if one is not open on the screen.
    On the Tools menu, click Options.
    Click the Calculation tab.
    In the Calculation section, click Manual, and then click OK.
    On the File menu, click Open and try to open the file.
    OR

    On the File menu, click Open. Then, browse from the current folder to the folder that contains the damaged file, and click Cancel.
    Click New on the File menu, click File, and then click OK.
    Type =File Name!A1 in cell A1 of the new workbook, where File Name is the name of the damaged workbook. If the Select Sheet dialog box appears, select the appropriate sheet, and click OK.
    Select cell A1, and on the Edit menu, click Edit. Then, select an area that is approximately the same size as the range of cells that contain data in the damaged file, and then click Paste on the Edit menu.
    With the range of cells still selected, click Copy on the Edit menu.
    On the Edit menu, click Paste Special, select Values, and click OK.

    OR

    If you have the Microsoft Excel converter installed, you might be able to open your Excel workbook in Microsoft Word. If the file does open in Word, you will not be able to recover module sheets, dialog sheets, chart sheets, macro sheets, or any embedded charts. Also, you will not recover any cell formulas, only the results of those formulas that are currently in the cells.
    You can also open your Excel workbook in WordPad. If the file does open, you might recover Microsoft Visual Basic code in your modules and class modules. Search for the words "Sub" or "Function" to find your code.


    OR
    If you have Microsoft Excel Viewer installed, you may be able to open the Microsoft Excel workbook in Microsoft Excel Viewer, copy the cells, and paste the cells into a new workbook. However, you cannot recover module sheets, dialog sheets, chart sheets, or macro sheets. Also, you will not recover any cell formulas, only the results of those formulas that are currently in the cells.
    To download Excel Viewer 2003, or for more information, see Downloads on Microsoft Office Online.

    OR
    Enter the following macro code in a module sheet: Sub GetChartValues97()
    Dim NumberOfRows As Integer
    Dim X As Object
    Counter = 2

    ' Calculate the number of rows of data.
    NumberOfRows = UBound(ActiveChart.SeriesCollection(1).Values)

    Worksheets("ChartData").Cells(1, 1) = "X Values"

    ' Write x-axis values to worksheet.
    With Worksheets("ChartData")
    .Range(.Cells(2, 1), _
    .Cells(NumberOfRows + 1, 1)) = _
    Application.Transpose(ActiveChart.SeriesCollection(1).XValues)
    End With

    ' Loop through all series in the chart and write their values to


    ' the worksheet.
    For Each X In ActiveChart.SeriesCollection
    Worksheets("ChartData").Cells(1, Counter) = X.Name

    With Worksheets("ChartData")
    .Range(.Cells(2, Counter), _
    .Cells(NumberOfRows + 1, Counter)) = _
    Application.Transpose(X.Values)
    End With

    Counter = Counter + 1
    Next

    End Sub
    Insert a new worksheet into your workbook and rename it ChartData.
    Select the chart from which you want to extract the underlying data values. Note The chart can either be embedded on a worksheet or on a separate chart sheet.
    Run the GetChartValues97 macro.The data from the chart will be placed in the ChartData worksheet.


    --- I couldn't do the first couple of options because the commands were not available in Excel (I have Excel for Mac). I want to try the macro code you have provided, but I'm not sure how to do it.

  • melissa_rama Jan 26, 2009

    WebDoc666
    Rank: Wiz
    Rating: 79%, 55 votes
    post it some where and give the link and i will open it for u

    --- Even if I knew how to do that (post it and provide the link), I couldn't, because it is an internal corporate document (confidentiality).

  • melissa_rama Jan 26, 2009

    rylee_smith
    Rank: Wiz
    Rating: 81%, 46 votes
    Hi

    I think the file got corrupted due to virus or a macros error. Try restoring the system to the date when the file was running fine. You can restore the system by clicking on start menu>programs>accessories>system tools>system restore.

    When you click on the system restore it will ask you to restore the system to previous date, choose the date when the file was running fine.

    Before doing a system restore back up all your data as it might get deleted. Also make a copy of this excel file somewhere else before system restore.

    Ask for any assistance.

    Thanks
    Rylee

    --- Our office operates on Macs, so that command can't be followed

  • melissa_rama Jan 26, 2009

    frcs68
    Rank: Wiz
    Rating: 82%, 442 votes
    is the excel file link to other excel file or is it link to other database.
    in looking throught the error, seems like the database is corrupted. either SQL or MS Access.
    the excel worksheet will not connect if the link is broken, or the data can't be retrieved due to corrupted data.
    you need to talk to the IT department and have them rebuild the database server.

    --- the excel file is linked to other excel or word files. I'm not sure what SQL is, but nothing is linked to MS Access (we don't have that application). When the message window appears - asking to either ignore or fix links - is there no way to fix the links then? I tried, but obviously I don't know what I'm doing because the excel file still won't open...

  • melissa_rama Jan 26, 2009

    machadojr_fe
    Rank: Guru
    Rating: 85%, 70 votes
    please open excel then from within excel click open and then find the file and click the black arrow next to open and select open and repair. Please let me know what happens when you try this.
    Comment posted on Jan 26, 2009
    please try with read only and see if it opens

    --- the file will not open in 'read-only' mode

  • melissa_rama Jan 26, 2009

    P3NGYJ03
    Rank: Wiz
    Rating: 72%, 24 votes
    Hello and welcome to FixYa!,

    Have you tried a Clean Install of Excel- It May be a Corrupted file in Excel causing this

    If not send the File to Jackson-h@hotmail.com and i will Scan for viruses and try to Open

    I'm using Excel 2003 for Windows XP

    Hope this helps --P3NGYJ03


    --- Do you mean re-install excel and then try opening it? I could try that if nothing else works.

  • melissa_rama Jan 27, 2009

    machadojr_fe
    Rank: Guru
    Rating: 86%, 71 votes
    Comment posted on Jan 26, 2009
    Click here
    Please try this and let me know if it helps

    --- those excel add ins look great, but when I followed the demands, I discovered that those add-ins are not available on our system

  • melissa_rama Jan 27, 2009

    Comment posted on Jan 27, 2009
    could you please let us know what type of systems you are using so we can try and provide you more useful help

    also please try this

    Open Excel, go to Tools=>Options=>General tab and make sure Ignore Other Applications is not checked.

    Please post the results

    ---- We are using MS Excel 2004 on Macs, not a PC environment

×

18 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 123 Answers

Kernel Protection failure is caused when a program/hardware driver tries to access memory that is already in use by the operating system and is thus protected, causing the offending program/driver to crash.
Did you install any new hardware prior to the crashing? if so uninstall it & the drivers and try again.
Unless someone reprogrammed your excel macros to use memory that is protected -not a very easy thing to do so thats unlikely-
do you have another machine to copy your excel file to and try? thats a good way to see if its a driver fault, as it will not replicate the error usually.
My guess is that the spreadsheet is recoverable.
If you can e-mail the file to me I can have a look at it here. I understand that it may contain sensitive data and u may not want to do that....I also realise that your macros may not run on a different machine but it helps to identify the origin of the error.
Hope this helps a lil...


Posted on Jan 27, 2009

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Sergeant:

    An expert that has over 500 points.

  • Expert
  • 320 Answers

Hi,
With Excel closed, try re-registering Excel in Windows by
clicking on Start | Run | Open: excel /unregserver | OK | Open:
excel /regserver | OK.
Or click on the below link and try those... Might work.

http://www.officearticles.com/misc/files_dont_open_when_double-clicked_in_microsoft_office.htm

Thank you......

Posted on Jan 27, 2009

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Master
  • 19,396 Answers

The file does not open because it is damaged.

It it is not a matter of enabling or disabling Macros.

When you work on a file at programming level you should always save a backup.

All you can do is trying one of the following recovery tools, and cross your fingers:


Excel Recovery Tool


Recovery for Excel


Repair Excel File


Excel Recovery Software


Excel File Recovery and Date Tools


MS Excel file Recovery Software


Excel recovery toolbox


Excel recovery ExcelFIX


Excel recovery Software


How To Get Fix Full Version | Excel File Recovery


Posted on Jan 27, 2009

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Expert
  • 50 Answers

Try a nod32 anti virus system and see if that works

Posted on Jan 27, 2009

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 104 Answers

Normally when macro-enabling window box pops up at any MS-Office Applications, it means there is Unstable Program Code in your MS-Office Application.
You can resolve this error by installing a clean MS-Office or a new installation of a newer version (eg. Office 2007)

Best Regards
Van

Posted on Jan 26, 2009

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 741 Answers

Your file is corrupt with a virus or from broken links. the correct answer is to load your backup or call computer repair, or your IT guy to look at it.

Posted on Jan 26, 2009

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 86 Answers

Do you use some kind of CVS? for managing changes to the file?
if so you can compare versions to find out what really happen.

in the case of a corrupted file there are Excel Recovery Tools for this, either free or paid. use a search engine to find one that fits your needs  

Posted on Jan 26, 2009

  • Dr_Joseph
    Dr_Joseph Jan 26, 2009

    Let me explain better what CVS is. Any changes to files are transparently saved in a repository. you still keep it simple, but other functionalities are provided, such as history of versions, versions comparison, comments, and reverting to a previous version, to name a few.
    You can work directly from the repository and it acts just like windows explorer.
    This is a great option so you will not have the same problem again, and without having to do backups of data.

    There are few options to this but i can recommend Visual Source Safe as a reliable and easy to use tool.

×

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Expert
  • 177 Answers

Hello and welcome to FixYa!,

Have you tried a Clean Install of Excel- It May be a Corrupted file in Excel causing this

If not send the File to Jackson-h@hotmail.com and i will Scan for viruses and try to Open

I'm using Excel 2003 for Windows XP

Hope this helps --P3NGYJ03

Posted on Jan 26, 2009

  • Jackson Henney Jan 26, 2009

    That is Exactly What i'm Saying

    Can you send the File Anyway

    JACKSON-H@HOTMAIL.COM

    --BYE

×

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Master
  • 4,806 Answers

Hi there
I'm having Deja-vu with this one
Please send me the file to work with ............. leecom72@hotmail.com

Regards

Posted on Jan 26, 2009

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Genius:

    An expert who has answered 1,000 questions.

  • Master
  • 1,605 Answers

Is the excel file link to other excel file or is it link to other database.
in looking throught the error, seems like the database is corrupted. either SQL or MS Access.
the excel worksheet will not connect if the link is broken, or the data can't be retrieved due to corrupted data.
you need to talk to the IT department and have them rebuild the database server.

Posted on Jan 26, 2009

  • Frank
    Frank Jan 27, 2009

    the excel file will not work unless the SQL database is fixed. the link from excel is looking for the data that are stored in the SQL server and the link to certain file.

    Since the SQL server is no-functional, the link is broken, there for you get the fix link error. regardless what you do is is not going to be fix till teh SQL server is functional.

×

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Brigadier General:

    An expert that has over 10,000 points.

  • Master
  • 8,619 Answers

Hi

I think the file got corrupted due to virus or a macros error. Try restoring the system to the date when the file was running fine. You can restore the system by clicking on start menu>programs>accessories>system tools>system restore.

When you click on the system restore it will ask you to restore the system to previous date, choose the date when the file was running fine.

Before doing a system restore back up all your data as it might get deleted. Also make a copy of this excel file somewhere else before system restore.

Ask for any assistance.

Thanks
Rylee

Posted on Jan 26, 2009

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 565 Answers

Post it some where and give the link and i will open it for u

Posted on Jan 26, 2009

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 11,896 Answers

To manually repair a file

  1. On the File menu, click Open.
  2. In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
  3. Click Open and Repair, and then choose which method you want to use to recover your workbook.
OTHER WAYS TO OPEN THE FILE

  1. Start Excel and open a blank workbook if one is not open on the screen.
  2. On the Tools menu, click Options.
  3. Click the Calculation tab.
  4. In the Calculation section, click Manual, and then click OK.
  5. On the File menu, click Open and try to open the file.
OR

  1. On the File menu, click Open. Then, browse from the current folder to the folder that contains the damaged file, and click Cancel.
  2. Click New on the File menu, click File, and then click OK.
  3. Type =File Name!A1 in cell A1 of the new workbook, where File Name is the name of the damaged workbook. If the Select Sheet dialog box appears, select the appropriate sheet, and click OK.
  4. Select cell A1, and on the Edit menu, click Edit. Then, select an area that is approximately the same size as the range of cells that contain data in the damaged file, and then click Paste on the Edit menu.
  5. With the range of cells still selected, click Copy on the Edit menu.
  6. On the Edit menu, click Paste Special, select Values, and click OK.

OR

If you have the Microsoft Excel converter installed, you might be able to open your Excel workbook in Microsoft Word. If the file does open in Word, you will not be able to recover module sheets, dialog sheets, chart sheets, macro sheets, or any embedded charts. Also, you will not recover any cell formulas, only the results of those formulas that are currently in the cells.
You can also open your Excel workbook in WordPad. If the file does open, you might recover Microsoft Visual Basic code in your modules and class modules. Search for the words "Sub" or "Function" to find your code.


OR
If you have Microsoft Excel Viewer installed, you may be able to open the Microsoft Excel workbook in Microsoft Excel Viewer, copy the cells, and paste the cells into a new workbook. However, you cannot recover module sheets, dialog sheets, chart sheets, or macro sheets. Also, you will not recover any cell formulas, only the results of those formulas that are currently in the cells.
To download Excel Viewer 2003, or for more information, see Downloads on Microsoft Office Online.

OR
  1. Enter the following macro code in a module sheet: Sub GetChartValues97()
    Dim NumberOfRows As Integer
    Dim X As Object
    Counter = 2

    ' Calculate the number of rows of data.
    NumberOfRows = UBound(ActiveChart.SeriesCollection(1).Values)

    Worksheets("ChartData").Cells(1, 1) = "X Values"

    ' Write x-axis values to worksheet.
    With Worksheets("ChartData")
    .Range(.Cells(2, 1), _
    .Cells(NumberOfRows + 1, 1)) = _
    Application.Transpose(ActiveChart.SeriesCollection(1).XValues)
    End With

    ' Loop through all series in the chart and write their values to


    ' the worksheet.
    For Each X In ActiveChart.SeriesCollection
    Worksheets("ChartData").Cells(1, Counter) = X.Name

    With Worksheets("ChartData")
    .Range(.Cells(2, Counter), _
    .Cells(NumberOfRows + 1, Counter)) = _
    Application.Transpose(X.Values)
    End With

    Counter = Counter + 1
    Next

    End Sub
  2. Insert a new worksheet into your workbook and rename it ChartData.
  3. Select the chart from which you want to extract the underlying data values. Note The chart can either be embedded on a worksheet or on a separate chart sheet.
  4. Run the GetChartValues97 macro.The data from the chart will be placed in the ChartData worksheet.



Posted on Jan 26, 2009

  • 9 more comments 
  • Nate Stansfield
    Nate Stansfield Jan 26, 2009

    IF YOU NEED MORE INFO: (copy and paste this link in your browser)

    http://www.google.com/search?q=excel+fil...

  • Nate Stansfield
    Nate Stansfield Jan 26, 2009

    TRY THIS:

    Tools,

    Options, and in the

    >General tab, de-select the option "Ignore other applications."

    >


    OR






    To resolve
    this issue in Office 2007 Click on the Orb, and then click on "Excel
    Options", Select Advanced on the left hand side, on the right hand side
    remove the check mark from "Ignore other applications that use dynamic data exchange".































  • Nate Stansfield
    Nate Stansfield Jan 26, 2009

    you can also use QuickLook to at least see what is inside a Excel file.

  • Nate Stansfield
    Nate Stansfield Jan 26, 2009

    openoffice.org also opens excel documents


    I've had great success with corrupt files using

    OpenOffice. The most convenient version is the free NeoOffice/J which

    you can get here:

    http://www.neooffice.org/



  • Nate Stansfield
    Nate Stansfield Jan 27, 2009

    How to Create a Personal Macro Workbook

    loadTOCNode(2, 'moreinformation');


    The easiest way to create a Personal Macro Workbook is to record a "dummy" macro. To do this, follow these steps:


    1. Start Excel so that only a new workbook is open. On the Tools menu, point to Macro, and then click Record New Macro.

    2. In the Record Macro dialog box, click Personal Macro Workbook in the Store macro in list.

    3. Click OK. Because you are creating a "dummy" macro, do not click or type anything.

    4. In the toolbar that appears, click the Stop Recording button.

    5. On the Excel menu, click Quit. Or, for versions of Excel earlier than Excel X, click Quit on the File menu.

    6. Click Save when you are prompted to save your changes.

    When you start Excel, this Personal Macro Workbook opens as a hidden
    workbook. By default, it is stored in the following path, depending on
    your version of Excel.

    In Excel 98 and in Excel 2001
    Microsoft Office folder:Office:Startup:Excel:Personal Macro Workbook
    In Excel X or in later versions

    Hard disk drive:Applications:Microsoft Office version:Office:Startup:Excel:Personal Macro Workbook


    Back to the top
    How to Use a Personal Macro Workbook

    loadTOCNode(2, 'moreinformation');


    To write or edit VBA code in a Personal Macro Workbook, follow these steps:


    1. On the Tools menu, point to Macro, and then click Visual Basic Editor.

    2. In the "Project - VBA Project" window, double-click VBAProject (Personal Macro Workbook) to display the Modules folder within.

    3. Double-click the Modules folder to display any modules in this project, and double-click a module to display its code or blank code sheet.


      You can use this code sheet to write and edit VBA code.


  • Nate Stansfield
    Nate Stansfield Jan 27, 2009

    THIS SOLUTION WORKED FOR ANOTHER PERSON WITH YOUR SAME PROBLEM:

    First try the standard fix(es)......Tools>Options>General uncheck "ignore

    other applications
    "



    OR Re-register Excel.



    Start>Run "excel.exe /regserver"(no quotes and note the space before the /

    mark).



    You may have to enter your full path to excel.exe....in that case surround

    with quotes as in..... "C:\mypath\to Excel\somewhere\excel.exe" /regserver



    In your case it sounds more like re-registering first would be best.






  • Nate Stansfield
    Nate Stansfield Jan 27, 2009

    ANOTHER OPTION IS TO TRY:

    you can download a hex-reader from PepiMK's website (Spybot S&D).
    The download you want is FileAlyzer. This should allow you to at least
    recover the latest information in the file and record it to one of your
    backups. Might involve a bunch of typing however.



    http://spybot.safer-networking.de/in...g...



    This one looks even better, but I haven't tried it.

    It fixes Excel spreadsheets.

    Download the free demo from here:

    http://www.officerecovery.com/excel/


  • Nate Stansfield
    Nate Stansfield Jan 27, 2009

    ALSO YOU MUST HAVE EXCEL 2004 COMPLETELY UPDATED AS WELL AS YOUR OPERATING SYSTEM.
    > The OS is version 10.5.6, which is the most current update. Apologies for

    > forgetting to include that!

    >

    > I'm don't think it's a permissions problem. The issue is persistent across

    > accounts. I did repair disk permissions through Disk Utility, but the issue

    > still exist. I believe the user does have necessary permissions to open these

    > files, as they work just fine if Excel is left at version 11.0.0 rather than

    > 11.5.3 or the they are opened with Apple Numbers or OpenOffice.

    >

    > Workbooks will not open even if done through File => Open, nor will they open

    > if Excel is launched while holding the Shift key.

    >

    > I did check the error logs in Console and the following appears whenever I

    > try to open one of the problematic workbooks:

    >

    > [339] kCGErrorIllegalArgument: CGXGetWindowWorkspace: invalid window id: 6c

    >

    > Other window ID's have been 40, 4a, and 75, if that makes a difference.



    While starting XL with the shift key down SHOULD prevent preference

    corruption from occurring, the first thing I'd try is, with ALL Office

    apps closed, deleting or renaming any



    com.microsoft.*



    files and the Microsoft folder in ~:Library:Preferences (where ~ is the

    home directory).



    Next, I'd try creating a fresh user account and seeing if the problem

    persisted. If it doesn't, some other app/haxie is interacting with XL in

    your user's account.



    If this happens in a fresh user account, too, I'd try round-tripping a

    couple of workbooks through XML/Web Page format to see if it's workbook

    corruption issue.






  • Nate Stansfield
    Nate Stansfield Jan 27, 2009

    If the file extension is a dBASE II/-IV file type. Since that application was never
    produced for Mac the file type is not registered in Mac OS & therefore isn't
    a recognized/supported file type.

    As another poster responded, Mac Excel _may_ be able to open the file if you
    set the Enable: option to All Documents. However, even PC Excel can't open
    *all* .dbf files - there are a number of variables that come into play.

    Interestingly enough, when you save the file the Save As dialog's Format:
    list *does* provide a choice of dBASE formats from which to choose - among
    others that aren't specifically listed in the Open dialog's Enable: list:-)


  • Nate Stansfield
    Nate Stansfield Jan 27, 2009

    IF YOU DON'T HAVE AN EXCEL 2004 USERS MANUAL (copy and paste this link in your browser)

    http://books.google.com/books?id=PlBJ4rI...


  • Nate Stansfield
    Nate Stansfield Jan 29, 2009

    HERE IS SOME LINKS ON SQL SERVER LINK REPAIRS"

    http://msdn.microsohttp://stackoverflow....
    Link to SQL Server Database-us/library/ms188
    How to use Excel with SQL Server linked servers and distributed ...279.aspx

    How to create a SQL Server linked server to DB2

×

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Mentor:

    An expert who has written 3 tips or uploaded 2 video tips.

  • Expert
  • 202 Answers

Check out your micro file is in right place in vb editor
it is in same project where the excel files are

Posted on Jan 26, 2009

  • yashan.co.in Jan 26, 2009

    its stop updating it and work fine.

×

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 916 Answers

Please open excel then from within excel click open and then find the file and click the black arrow next to open and select open and repair. Please let me know what happens when you try this.

Posted on Jan 26, 2009

  • 2 more comments 
  • machadojr_fe Jan 26, 2009

    please try with read only and see if it opens

  • machadojr_fe Jan 26, 2009

    Click here
    Please try this and let me know if it helps


  • machadojr_fe Jan 27, 2009

    could you please let us know what type of systems you are using so we can try and provide you more useful help

  • machadojr_fe Jan 27, 2009

    also please try this

    Open Excel, go to Tools=>Options=>General tab and make sure Ignore Other Applications is not checked.

    Please post the results


×

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 112 Answers

I am taking a guess at a virus or a bad sector on the hard drive.
Do you not have a backup program? You could restore it to it`s previous operating state.
It`s trying to open but not being recognized past the first sector.
If it is a virus or dreaded (worm), then it will embed itself deeper the more you try to open it.
Hope this helps.

Posted on Jan 26, 2009

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 3,940 Answers

#1 ensure that this document has the same issues on another system. If it does, the file is definitely the issue.
#2 Scan the document for viruses/spyware and see if it can be repaired if infected.
#3 Check with your team, see if anyone was pessimistic enough to create a backup of the file.

The research I was able to do didn't give any solution to fixing the document only trying to duplicate the issue with another file

Posted on Jan 26, 2009

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Master
  • 13,433 Answers

If the document doens't open on any computer, the file is corrupt
there are recovery software you can try such as

http://www.officerecovery.com/excel/

http://www.excelfilerecovery.com/

Please from now on, take a backup of the file and store it at another location so incase this happens again you will have a backup to restore and continue from.

Posted on Jan 26, 2009

  • Ekse Jan 26, 2009

    Take dayly or half day backups of the file and store them.

×

6 Suggested Answers

SOURCE: Excel Macro

Try these links you could find out

http://www.vbaexpress.com/kb/getarticle.php?kb_id=706
http://www.computing.net/programming/wwwboard/forum/5902.html

Posted on Dec 17, 2007

mcc99
  • 51 Answers

SOURCE: Macros Help PLZ

Change the file ending back to .xls, open the file, enable macros, then try renaming the file to the new extension.

Posted on Mar 15, 2008

  • 26 Answers

SOURCE: MS EXCEL 2000 corrupted workbooks/worksheets

it sounds like you are going over the limits of the program these are the specs. I would recommend dividing up the data if you can. or moving it to a database that can act like excel and hold more data.

Posted on Apr 29, 2008

  • 67 Answers

SOURCE: Macros

After you record your macro do the following.
Open the excel file contains the macro. Go to tools and go to macro and click on macros. Select the macro you wish to add the close operation. Click on Step into... This will open up the visual basic editor. In the code window, at the bottom row you will see End Sub. Right before that row, type workbooks.close
Save the macro by clicking the save button. And you can run your macro to see if it works. I tried, it does :) Good Luck :)

Posted on Feb 24, 2009

  • 67 Answers

SOURCE: tools protect workbook& sheet

Open the protected sheet... Go to edit and click select all. Go back to edit and click on copy. Open a new excel sheet, go to edit and click on paste. Now you have the copy of the protected sheet without the protection.

Posted on Feb 25, 2009

Keynan
  • 977 Answers

SOURCE: on a shared workbook, I

Hello!

Try protecting (locking) those columns that you're trying to hide...
Follow the instructions here (you can switch to a different version's instructions at the top).

In case of a problem or clarification or my solution was insufficient, don't hesitate to post me a reply before rejecting my answer.
If you are satisfied, rate my solution with the "thumbs" or (even better) add a testimonial.

Good luck & best regards,
Pelu.

Posted on Apr 04, 2011

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Excel 2003 worksheet slow in 2007


Hi Lee, I have recently experienced the same thing. When Excel 2007 or later opens an Excel 97-2003 .xls file, there are major issues of speed. The file is opened in compatibility mode. The best thing to do would be to open the file, then save as (keep the same name if you like) an Excel 2007 .xlsx document (or .xlsm document if there are macros). Close the file, then reopen it, and the compatibility mode issue will be gone. You can now use the newly saved file as a normal Excel 2007 file. Hope this helped.

Mar 25, 2014 | Microsoft Office Professional 2007 Full...

1 Answer

Hyperlink other document in excel button


The easy way (but labor intensive) is to put the file names in a column (can be any name you want or the pdf file name), right click on a cell, hit insert hyperlink, and in the address field at bottom, put in the file pdf file name. You would have to do this for each of your 100 files.

If you want to automate it, create a column with the directory path name, a 2nd column with the full file names, a 3rd column where you concatenate the two previous columns to create the full path, and then use the hyperlink command to provide the link:


Folder name Filename Concatenated LINK ../excel/ file1.pdf ../excel/file1.pdf file1.pdf ../excel/ file2.pdf ../excel/file2.pdf file2.pdf ../excel/ file3.pdf ../excel/file3.pdf file3.pdf

Here are the formulas behind this:
A B C D Folder name Filename Concatenated LINK ../excel/ file1.pdf =CONCATENATE(A2,B2) =HYPERLINK((C2),B2)
../excel/ file2.pdf =CONCATENATE(A3,B3) =HYPERLINK((C3),B3)
../excel/ file3.pdf =CONCATENATE(A4,B4) =HYPERLINK((C4),B4)
This should work like a charm and the other advantage is that excel won't rename your path locally depending on weather a file is open or not).

Feb 21, 2014 | Microsoft Excel for PC

1 Answer

Hi Team, I have created macro in MS Excel2007 and after executing macro output file will be created MS Excel2003. Once MS Excel2003 file closed and reopen all the formating lost. How can overcome this...


It is unlikely that you can really overcome this as Office 2003 and Office 2007 have completely different file formats and structures. But if you output it to an Office 2007 file and use the Microsoft converter for Office 2003 than it may work. The converter can be found here

Jun 22, 2011 | Microsoft Excel 2007 0882224152648 Full...

1 Answer

How i can crack the password of excel sheet..............


Hi,

Have tried downloading the password.xla? If not, below is the link:

http://www.straxx.com/excel/password.html

Just add this xla to your addins and then open your excel document. The sheet will be automatically be unprotected.

Feb 09, 2011 | Microsoft Office Professional 2007 Full...

2 Answers

Whenever I open a new spreadsheet now it automatically opens up a spreadsheet calles PERSONAL. Why is that and how can I get rid of it... I think it started after a did a macro but I am not sure. Thanks,...


You're right - it was caused by recording a macro. When you record a macro you are given the option to store the new macro in "This Workbook", a "New Workbook" (the default), or in a "Personal Macro Workbook". It looks like you selected "Personal Macro Workbook".
The recorded macro is stored in a special workbook called "Personal.xls". This workbook is loaded every time Excel is loaded. If you don't want this workbook loaded, then just delete it or rename it.
The file is buried deep in Microsoft's application data area. On my Vista computer it's in C:\Users\frogfund\AppData\Roaming\Microsoft\Excel\XLSTART On my Windows XP computer it's in C:\Documents and Settings\frogfund\Application Data\Microsoft\Excel\XLSTART. Depending on your computer your Personal.xls might be in a slightly different location. You might need to do a search using Windows Explorer.
If you are still having troubles finding personal.xls 1. Open Excel, 2. Open the Visual Basic editor (hit Alt-F11 or click Tools-Macro-Visual Basic Editor) 3. Click Tools-References to bring up the references dialog 4. Click on VBAProject in the list. The file location will be displayed near the bottom of the dialog box. Sometimes this might be cut off at the end, but it should give you a good idea where the file is located. 5. Click Cancel to close the dialog.

Sep 23, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

While using Execl , we are getting compatibility


.xls files opened in Excel 2007 is "always" in "Compatibility Mode" since default 2007 excel files have .xlsx extensions

Sep 16, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Macros


After you record your macro do the following.
Open the excel file contains the macro. Go to tools and go to macro and click on macros. Select the macro you wish to add the close operation. Click on Step into... This will open up the visual basic editor. In the code window, at the bottom row you will see End Sub. Right before that row, type workbooks.close
Save the macro by clicking the save button. And you can run your macro to see if it works. I tried, it does :) Good Luck :)

Aug 18, 2008 | Microsoft Excel for PC

5 Answers

Microsoft excel file dose not open autometically


hi Friends

here is the solution ifi Excel opens without opening any file after double clicking on the excel file,

1. Tools>Options>General uncheck "Ignore other Applications"
2. Exit Excel and try again
If this doesn't work try to re-register Excel
1. Close Excel first and On the Windows Taskbar
2. Start>Run "excel.exe /unregserver"(no quotes)>OK.
3. Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver

if there is anyother issue in which may i help u then feel free to contact me
kamal_lalwani@dell.com
kamal0806us@yahoo.com
+9742128873 /

Jan 23, 2008 | Microsoft Excel for PC

1 Answer

Macros Command Help


Your Excel may have a different "Macro Security" setting. Your "Macro Security" can be adjusted: Tools, Macro, Security. I highly recommend the "Medium" setting. This will prompt you when an Excel file is opened that contains Macros to Enable or Disable. If you choose a security setting of "Low" please be very careful as this will allow Macros to run without any notice, VERY DANGEROUS.

Oct 04, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft EXCEL 2004 for Mac Logo

Related Topics:

168 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18304 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...