Announcement

Collapse
No announcement yet.

Excel 2003 crashes when creating link to cell on a different tab

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel 2003 crashes when creating link to cell on a different tab

    Symptom: When trying to display content from another cell on a different tab (sheet) by entering "=" or "+" in the destination cell, Excel crashes when a different tab is selected.

    Cause: Problem is caused by Microsoft Security Update for Office 2003 (KB 973475) EXCEL and corrupt .xlb file in user profile.

    Solution for Windows XP


    • Close all Excel Spreadsheets
    • Open Start Button>>Control Panel>>Add or Remove Programs
    • In Add Remove Programs, check the box “Show Updates”
    • Scroll to Microsoft Office 2003.
    • Under Microsoft Office, locate Security Update for Office 2003 (KB 973475) EXCEL. Select this update and select Remove button. Close Control Panel when done.
    • Open Windows File Explorer or My Computer and select Tools>>Folder Options>>View Tab. Verify these settings: Under Hidden files and folders, select Show hidden files and folders. Underneath Show hidden files and folders uncheck Hide extensions for known file types. Select OK to close window.
    • After update is removed, open Windows File Explorer and navigate to \Documents and Settings\%USERPROFILE%\Application Data\Microsoft\Excel (%USERPROFILE% matches your login ID)
    • Rename file Excel11.xlb to Excel11.xlb.bak. The number on the file name may vary but the file will start with Excel and have a .xlb file name extension.
    Start Excel, open a spreadsheet and test linking

    When doing Windows updates on your machine, select Custom Install and uncheck Security Update for Office 2003 (KB 973475) EXCEL. You should get a prompt with a checkbox for Don’t notify me about these updates again. Check this checkbox.

    Hopefully Microsoft will release an updated patch that will supercede this update.
Working...
X