I have a complex Excel workbook (43 mb) and set the Conditional formatting on one of the sheets using VBA and this works ok. I am using an 32-bit English version of Excel. Save, close re-open no problems.
Another user has a 64-bit Dutch version of Excel and after he opens the same workbook, runs the same code it still works. Note the VBA code translates the English conditions to Dutch. This all seems to work Ok.
However if he then saves the file the workbook is corrupt and can not be opened.
Error:
"We found a problem with some content in ....." Do you want us to try to recover etc...
Has any else had these sort of problems?
Another user has a 64-bit Dutch version of Excel and after he opens the same workbook, runs the same code it still works. Note the VBA code translates the English conditions to Dutch. This all seems to work Ok.
However if he then saves the file the workbook is corrupt and can not be opened.
Error:
"We found a problem with some content in ....." Do you want us to try to recover etc...
Has any else had these sort of problems?
