Hi,
Has anyone come across the problems mentioned in the subject?
I update monthly reports in Excel. Since our OS upgraded from XP to Windows 7, our Microsoft Office is 2010 now (but I really really miss XP and old version of Office). I haven't played with the new Excel much yet. But I have had quite a few problems.
First of all, some of the ComboBoxes are not working, i.e., if I click the dropdown of a Combobox, other boxes are supposed to respond but they don't. As I run the macros associated with those Comboboxes, I will get a trouble code '1004' and message saying something like 'Application Define error...'.
Then as long as a cell is selected, a dropdown mark can be seen at the cell, like Data Validation dropdowns. Data on most of the sheets will turn corrupt, or gone.
There might be more but this is what I have now.
Is there any cure for this?
Thanks in advance.
Has anyone come across the problems mentioned in the subject?
I update monthly reports in Excel. Since our OS upgraded from XP to Windows 7, our Microsoft Office is 2010 now (but I really really miss XP and old version of Office). I haven't played with the new Excel much yet. But I have had quite a few problems.
First of all, some of the ComboBoxes are not working, i.e., if I click the dropdown of a Combobox, other boxes are supposed to respond but they don't. As I run the macros associated with those Comboboxes, I will get a trouble code '1004' and message saying something like 'Application Define error...'.
Then as long as a cell is selected, a dropdown mark can be seen at the cell, like Data Validation dropdowns. Data on most of the sheets will turn corrupt, or gone.
There might be more but this is what I have now.
Is there any cure for this?
Thanks in advance.
