A
Anand Nichkaode
Hi all,
We are using Excel 2007 for reporting in our organization.
Basically there is a Java web application which instantiates Excel
with an XLAM. This XLAM opens a Report Template(an .xls, .xlsm file).
The Template has a data sheet where data is pasted on number of ranges
and the Report sheet which shows the final report based on the data
from the DataSheet. The ReportSheet contains formulas to show the final
output. It could also contain Charts/Graphs. The data pasted on ranges
is fetched from SQL server. And finally when Macro is run the Template
is saved as a Final Report somewhere on the Report Server.
All these operation occurs on the template saved locally.
The Excel runs in the background in all this process. There could be
multiple instances of Excel running on the same box. The instances run
under separate WindowStations.
I get the following error message at randomly,
Microsoft Office Excel cannot access the file 'C:\Documents and
Settings\XXXXXXXX\Local Settings\Temporary Internet Files\Content.MSO'. There
are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open
workbook.
If anybody has any idea about the error message please let me know. And also
how to fix the issue.
Any help appreciated.
Thanks in advance.
We are using Excel 2007 for reporting in our organization.
Basically there is a Java web application which instantiates Excel
with an XLAM. This XLAM opens a Report Template(an .xls, .xlsm file).
The Template has a data sheet where data is pasted on number of ranges
and the Report sheet which shows the final report based on the data
from the DataSheet. The ReportSheet contains formulas to show the final
output. It could also contain Charts/Graphs. The data pasted on ranges
is fetched from SQL server. And finally when Macro is run the Template
is saved as a Final Report somewhere on the Report Server.
All these operation occurs on the template saved locally.
The Excel runs in the background in all this process. There could be
multiple instances of Excel running on the same box. The instances run
under separate WindowStations.
I get the following error message at randomly,
Microsoft Office Excel cannot access the file 'C:\Documents and
Settings\XXXXXXXX\Local Settings\Temporary Internet Files\Content.MSO'. There
are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open
workbook.
If anybody has any idea about the error message please let me know. And also
how to fix the issue.
Any help appreciated.
Thanks in advance.