Hi all,
I encountered this problem using a VB programme in excel. Basically, I have this excel database of people. The programme will calculate the number of people in the different departments and summarise it into a table on a separate sheet.
This programme works fine on most computers. However, on one particular computer, it gives me a totally different set of data (wrong data). Can anyone tell me whats the problem? Is there some settings on excel that I have to take note?
BTW, Im using excel97.
Thanks in advance.
Do you have the VB program codes?
On most computers, which version of Excel are they using?
If you can paste the codes here, that would help a lot.
Erm...
Its not possible cos the program consists of several modules. The problematic one is ~50 pages long when printed out.
The computers are using excel97. Since the programme can work prefectly fine on most computers, I wonder if it has something to do with the settings of that particular com. Like the Add-Ins or something?