Toolbox object linkcell problem

[Guest]

I have an application that has been in use for many months, but today a new
problem began occurring. The workbook has numerous combo boxes, checkboxes,
and option buttons linked to cells beneath them with the linkcell property.
When I select the value, it fills in the cell just fine. However, when I
clear the cell value, the associated object value no longer clears. I use a
"Clear All" button with a macro that deletes the cell values to clear all the
selections at once, but it no longer works. It also doesn't work to just
delete the cell values manually. If I go into Properties, delete the
linkcell value, and then reenter it, the selection clears, but if I reselect
another value the problem returns. I reloaded the workbook from a backup
from a week ago, but that didn't help either. Any suggestions?

 

[Guest]

Well, today it seems to be working fine. I'm guessing that the file was
corrupted and that after reloading it from a backup tape, I also needed to
reboot.

 

[Guest]

The problem came back again, but this time I found the solution. In Tools |
Options, the Calculation option was set to Manual. I changed it back to
Automatic and the problem went away.