Skip to Content
Former Member
Dec 16, 2008 at 01:23 PM

Error with Excel 2007


Dear All,

We developed a planning application using BPS. The existing systems had Excel 2003 installed in them. The Excel layouts were designed with heavy Macro coding in the background.

Recently Excel 2007 was installed in our machines. But, unfortunately, the values displaying on the Excel are separated by comma instead of decimals (this is an excel setting,which was also changed, but still the error exists). As a result, the data save on the excel always gives an error due to the comma.

Is there any way, we can overcome this error. Also the macros do not work when the planning folder is executed.

There is no problem when the same layouts are run on Excel 2003.

Any suggestion/recommendations/solution would be appreciated.