Excel 2003 crash by linking

You state that you are linking from other workbook files. Is this happenning with any workbook, or just in the sample provided?

What type of content do you have in your workbook ? Is it loaded with formulae, arrays or macros, conditional formatting, formatting, the size of data, pivots, etc. ? Be clear on that. Moreover, did you search the Microsoft KB Articles for your error on this website ?

Click Here Please

My workbooks contains only formulas, formatting cell and linking from others worksheets, no macros or forms. I worked with the same worksheets without error so already long.

By linking does Excel to crash.

I have a similar problem (I think): Fully patched XP machine, Excel 2003 (SP3). No add-ins (COM or otherwise) just vanilla Excel.

To replicate my problem - create a new workbook, add some data to a sheet and freeze panes (horizontal, vertical, doesn't matter). Select a cell anywhere on the sheet with frozen panes, start entering a formula by typing equals (=) and then click on a worksheet tab to refer to a cell in another worksheet ... Excel crashes at this point, every time.

If I unfreeze the panes, or use the formula bar and type the cell reference in manually, then no problem.

The same Excel file on two other identical machines (patch level etc.) does not crash on one, but does the other.

I've had some success with killing the user profile but the problem comes back eventually ... complete mystery.

If this helps fill in any gaps or triggers anything with your problem Paul (P_Lark) then that's great. Hopefully someone knowledgeable here can help us further. My suspicion is a recent Windows/Office Update is to blame but have yet to pinpoint.

Thanks,

Sam.

Hello Sam,

thank you verry match for your advice and help.
I must all that try (unfreeze, insert link manualy ).
Thanks

Paul

Did you search for your error problem on Microsoft Knowledge Base ? I wonder if that above solution is a concrete one..

I searched for any solution in Microsoft Knowledge Base, MS Comunity , TechArena, TEchGui.

Problem is possible 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.
(from http://forums.techarena.in/office-update-service/1271719.htm -
http://www.petri.co.il/forums/showthread.php?p=188311 )

I must that prompt to do.

Paul.

Did you try creating a new profile in Windows XP too ? Reinstalling or Uninstalling & Reinstalling could also do no harm...

Crash is gone! Excel works a excelent !

Problem realy caused by Microsoft Security Update for Office 2003 (KB 973475) EXCEL and corrupt .xlb file in user profile.
I uninstalled from my PC KB_973475 and deleted file Excel11.xlb... problem is away!

Thanks to all for help.

Paul.