Hi,
One of my clients had created a few combination chart in excel 2003, to display a certain scorecards. However, due to company policies, we had to move to Excel 2010, and since then we are unable to see a few of them (2 types, specifically).
When we open the previous file in 2010, firstly (before even enabling macros) we get a error which says: 'File error: data may have been lost.' Then (after enabling the macros), it gives another error message: 'This application is about to initialize ActiveX controls that might be unsafe....'
[Earlier, I had found out that there was a missing calendar control, and so, I had copied the old-one (mscal.ocx, from a 2003 machine) and then registered it successfully on the 2010 machine]
After all the calcs, it is unable to show a few chart objects.
I tried stopping the macro and checked, the chart area objects are not available in the sheet.
Please let me know some possible cause or the solution to this issue.
One of my clients had created a few combination chart in excel 2003, to display a certain scorecards. However, due to company policies, we had to move to Excel 2010, and since then we are unable to see a few of them (2 types, specifically).
When we open the previous file in 2010, firstly (before even enabling macros) we get a error which says: 'File error: data may have been lost.' Then (after enabling the macros), it gives another error message: 'This application is about to initialize ActiveX controls that might be unsafe....'
[Earlier, I had found out that there was a missing calendar control, and so, I had copied the old-one (mscal.ocx, from a 2003 machine) and then registered it successfully on the 2010 machine]
After all the calcs, it is unable to show a few chart objects.
I tried stopping the macro and checked, the chart area objects are not available in the sheet.
Please let me know some possible cause or the solution to this issue.