Linking cells on two worksheets shuts Excel Down


C

cfogene

Whenever I try to start a formula in a cell on a worksheet (tab), as soon as
I click on the tab i want to retrieve the data from Excel shuts down.
 
Ad

Advertisements

Joined
Jan 15, 2010
Messages
1
Reaction score
0
If:

You are running Excel 2003 SP3 and

The worksheet in which you are entering the formula has frozen panes,



Check to see if your computer has been updated with Security patch KB973475. This will cause what you describe. I read the MS documentation at http://support.microsoft.com/kb/973475 and the thread at http://www.mrexcel.com/forum/showthread.php?t=431416.



I removed the patch as discussed in the thread and renamed C:\Documents and Settings\<>\Application Data\Microsoft\Excel\excel11.xlb. I restarted Excel and have not had any problems.



Hope it helps. Cheers.
 
Ad

Advertisements

R

Robert Flanagan

I would completely un-install Office, reboot, and re-install.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top