locked
Microsoft Excel has encountered a problem and needs to close. RRS feed

  • Question

  • Every time I try to hit save on my excel document(only this file) I get the following error, "Microsoft Excel has encountered a problem and needs to close."  This file involves a lot of formulas and links from tabs.  It also links information from a similar excel file.

    I update this file with information on a daily basis for the last 3 years.....

    What might be my problem?

    Tuesday, November 26, 2013 3:42 PM

Answers

  • Re:  "I update this file with information on a daily basis for the last 3 years"

    Have you ever cleaned the worksheet(s)?

    Try:  SaveAs as a HTML file.
    If that suceeds then SaveAs an Excel file.
    '---
    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    • Marked as answer by Tony Chen CHN Monday, December 9, 2013 4:58 AM
    • Edited by James Cone Saturday, October 29, 2016 1:51 AM
    Wednesday, November 27, 2013 12:14 PM