![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
Currently I am programming in VBA and a problem has come up.
Since my last changes my cells won't update until I double click them. I can't find what caused this change in behaviour... does anyone know how I can correct this? Thanks in advance Thijs van Bon |
| Ads |
|
#2
|
|||
|
|||
|
Hi Thijs,
Try: Tools | Options | Calculation | Automatic --- Regards, Norman "ties" > wrote in message ... > Currently I am programming in VBA and a problem has come up. > > Since my last changes my cells won't update until I double click them. > > I can't find what caused this change in behaviour... does anyone know how I > can correct this? > > Thanks in advance > Thijs van Bon > > |
|
#3
|
|||
|
|||
|
This really is strange... After saving and opening my file several times in
succession the problem was solved... But now when I try to go the options menu Excel crashes. So I guess my Excel installation must be corrupt or something... I'll try reinstalling. Thanks Thijs "Norman Jones" > schreef in bericht ... > Hi Thijs, > > Try: > > Tools | Options | Calculation | Automatic > > > > --- > Regards, > Norman > > > > "ties" > wrote in message > ... > > Currently I am programming in VBA and a problem has come up. > > > > Since my last changes my cells won't update until I double click them. > > > > I can't find what caused this change in behaviour... does anyone know how > I > > can correct this? > > > > Thanks in advance > > Thijs van Bon > > > > > > |
|
#4
|
|||
|
|||
|
have you tried closing excel and rebooting?
-- Regards, Tom Ogilvy "ties" > wrote in message ... > Currently I am programming in VBA and a problem has come up. > > Since my last changes my cells won't update until I double click them. > > I can't find what caused this change in behaviour... does anyone know how I > can correct this? > > Thanks in advance > Thijs van Bon > > |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Bizarre Excel 03 Problem - autosum not updating when cells are cha | Angela | Excel Worksheet Functions | 2 | June 30th 07 01:48 AM |
| Problem updating Excel using ado.net | Lisa[_11_] | Excel Programming | 4 | July 29th 04 03:54 PM |
| Problem with updating of texts | Lieven Mettepenningen[_2_] | Excel Programming | 0 | January 19th 04 01:57 PM |
| Updating worksheet problem | HamishM[_4_] | Excel Programming | 2 | December 20th 03 04:25 AM |