473,837 Members | 1,518 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

Hi All,
We are in the process of Upgrade Excel 2003 (Office 2003) to Excel 2007
(Office 2007) for one of web application.
This web application is using Excel (Pivot Table) reports. With Excel 2003
application (Reports) works ok.
But when Office 2003 is upgraded to Office 2007 Excel reports stops working.

It Log the error “Exception from HRESULT: 0x800A03EC.” In database.

Condition:
1) Existing web Application in production (office 2003 installed on
production server)
2) Upgrade to Office 2007 on server , run the excel report
3) Excel Pivot Table reports stops working Log above error in error
database.

Could any one come across this difficulty / Issue?
Please Suggest appropriate solution if any one knows.

Thanks and Regards
Shashank P Kulkarni

Oct 5 '07
15 5366
Mark, why do you think it is never going to work? What exactly will stop it
from working?

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless Author Plug
OWC Black Book 2nd Edition
Exclusively on www.lulu.com/owc
$24.99
"Mark Rae [MVP]" <ma**@markNOSPA Mrae.netwrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..
"Gorgo" <Ma************ *@gmail.comwrot e in message
news:11******** **************@ i38g2000prf.goo glegroups.com.. .
>I think you missundestand Shashank. He said that he have problem with
excel object not with OWC.

To be honest I've enconter the same problem and stuck looking for some
solution. If anyone have some ideas what could be wrong then I'll
really appreciate it.

going into more details I need to add that I get this error message
only when I call SaveAs method and pass as FileFormat value diffrent
the "Type.Missi ng".

Read the thread again. If you're trying to use server-side Office
automation in ASP.NET, this is never going to work...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 19 '07 #11
"Alvin Bruney [MVP]" <some guy without an email addresswrote in message
news:u5******** ******@TK2MSFTN GP03.phx.gbl...
Mark, why do you think it is never going to work? What exactly will stop
it from working?
We've been here before, Alvin...

http://support.microsoft.com/default...US;q257757#kb2
http://support.microsoft.com/default.aspx/kb/288367
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 19 '07 #12
We've been here before, Alvin...

Precisely. You said it doesn't work. These articles do not support you
claim. There is a difference between software not working and software not
being supported. For instance, in the second article you linked, it
indicates:

<quote>Regardle ss, it may be absolutely required to use Office in this
manner [server side automation]. </quote>

Even Microsoft recognizes that applications will be run in this manner even
if there is no product support for this approach. Developers simply choose
to manage the risk. And that is one reason why you see developers coming
here for server-side automation help. Indicating that it won't work is
simply technically incorrect. By the way, i have personally gotten Microsoft
product support to help me solve server-side office automation issues even
if their official statement claims otherwise. These people do understand the
dollar impact of having production software go down. There are lots of
applications out there that automate office on the server in the real
world - I personally get numerous requests for help in this area. The chief
reason for developers proceeding with office server automation is that
microsoft has provided no suitable, cost-effective alternative.

I recommend you modify your stance to Office server automation is not
supported.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless Author Plug
OWC Black Book 2nd Edition
Exclusively on www.lulu.com/owc
$24.99
"Mark Rae [MVP]" <ma**@markNOSPA Mrae.netwrote in message
news:OI******** ******@TK2MSFTN GP04.phx.gbl...
"Alvin Bruney [MVP]" <some guy without an email addresswrote in message
news:u5******** ******@TK2MSFTN GP03.phx.gbl...
>Mark, why do you think it is never going to work? What exactly will stop
it from working?

We've been here before, Alvin...

http://support.microsoft.com/default...US;q257757#kb2
http://support.microsoft.com/default.aspx/kb/288367
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 20 '07 #13
"Alvin Bruney [MVP]" <some guy without an email addresswrote in message
news:OG******** ******@TK2MSFTN GP05.phx.gbl...
>We've been here before, Alvin...

Precisely. You said it doesn't work. These articles do not support you
claim. There is a difference between software not working and software not
being supported.
Yes, but the reason it isn't supported is precisely because it doesn't work,
at least, not with any sort of reliability. There may be instances where it
will work for a while, but it really is a disaster waiting to happen.
>For instance, in the second article you linked, it indicates:

<quote>Regardl ess, it may be absolutely required to use Office in this
manner [server side automation]. </quote>
LOL! But that's just marketing...:-) Fact is, there is never *any* need need
to use server-side Office automation because there are other products
available which do the job reliably - they're just not Microsoft products...

The article also says: "We do not recommend or support Automation to a
Microsoft Office application from an unattended user account." That's much
more than simply not supporting it - Microsoft actively does not recommend
it...

The article also says: "Caution Automation of any Office application from an
unattended, non-interactive user account is risky and unstable." The clue
here is "risky and unstable"...

The article also says: "Warning Office was not designed, and is not safe,
for unattended execution on a server." The clue here is "not safe"...

We're way beyond "not supported" here...
The chief reason for developers proceeding with office server automation
is that microsoft has provided no suitable, cost-effective alternative.
That is completely true. It's also completely irrelevant:
http://www.aspose.com/Products/Default.aspx
I recommend you modify your stance to Office server automation is not
supported.
How about: "Server-side Office automation is not support and not recommended
because it is unsafe, risky and unstable due to the fact that Office was not
designed to be used in this manner"...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 20 '07 #14
Don't get distracted, you said it doesn't work. That is simply not correct
and that is what I am pointing out.

To say that:
there is never *any* need need to use server-side Office automation
is a statement you simply should not be making, for obvious reasons. It's ok
to peddle the Aspose product, but not at the expense of technically
incorrect information.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless Author Plug
OWC Black Book 2nd Edition
Exclusively on www.lulu.com/owc
$24.99
"Mark Rae [MVP]" <ma**@markNOSPA Mrae.netwrote in message
news:uE******** ******@TK2MSFTN GP05.phx.gbl...
"Alvin Bruney [MVP]" <some guy without an email addresswrote in message
news:OG******** ******@TK2MSFTN GP05.phx.gbl...
>>We've been here before, Alvin...

Precisely. You said it doesn't work. These articles do not support you
claim. There is a difference between software not working and software
not being supported.

Yes, but the reason it isn't supported is precisely because it doesn't
work, at least, not with any sort of reliability. There may be instances
where it will work for a while, but it really is a disaster waiting to
happen.
>>For instance, in the second article you linked, it indicates:

<quote>Regard less, it may be absolutely required to use Office in this
manner [server side automation]. </quote>

LOL! But that's just marketing...:-) Fact is, there is never *any* need
need to use server-side Office automation because there are other products
available which do the job reliably - they're just not Microsoft
products...

The article also says: "We do not recommend or support Automation to a
Microsoft Office application from an unattended user account." That's much
more than simply not supporting it - Microsoft actively does not recommend
it...

The article also says: "Caution Automation of any Office application from
an unattended, non-interactive user account is risky and unstable." The
clue here is "risky and unstable"...

The article also says: "Warning Office was not designed, and is not safe,
for unattended execution on a server." The clue here is "not safe"...

We're way beyond "not supported" here...
>The chief reason for developers proceeding with office server automation
is that microsoft has provided no suitable, cost-effective alternative.

That is completely true. It's also completely irrelevant:
http://www.aspose.com/Products/Default.aspx
>I recommend you modify your stance to Office server automation is not
supported.

How about: "Server-side Office automation is not support and not
recommended because it is unsafe, risky and unstable due to the fact that
Office was not designed to be used in this manner"...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 20 '07 #15
Thanks all for your help.
We face this problem in QA environment and problem get solved by registring
office.
That team miss to register the Office 2007 :(


"Alvin Bruney [MVP]" wrote:
Don't get distracted, you said it doesn't work. That is simply not correct
and that is what I am pointing out.

To say that:
there is never *any* need need to use server-side Office automation

is a statement you simply should not be making, for obvious reasons. It's ok
to peddle the Aspose product, but not at the expense of technically
incorrect information.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless Author Plug
OWC Black Book 2nd Edition
Exclusively on www.lulu.com/owc
$24.99
"Mark Rae [MVP]" <ma**@markNOSPA Mrae.netwrote in message
news:uE******** ******@TK2MSFTN GP05.phx.gbl...
"Alvin Bruney [MVP]" <some guy without an email addresswrote in message
news:OG******** ******@TK2MSFTN GP05.phx.gbl...
>We've been here before, Alvin...

Precisely. You said it doesn't work. These articles do not support you
claim. There is a difference between software not working and software
not being supported.
Yes, but the reason it isn't supported is precisely because it doesn't
work, at least, not with any sort of reliability. There may be instances
where it will work for a while, but it really is a disaster waiting to
happen.
>For instance, in the second article you linked, it indicates:

<quote>Regardl ess, it may be absolutely required to use Office in this
manner [server side automation]. </quote>
LOL! But that's just marketing...:-) Fact is, there is never *any* need
need to use server-side Office automation because there are other products
available which do the job reliably - they're just not Microsoft
products...

The article also says: "We do not recommend or support Automation to a
Microsoft Office application from an unattended user account." That's much
more than simply not supporting it - Microsoft actively does not recommend
it...

The article also says: "Caution Automation of any Office application from
an unattended, non-interactive user account is risky and unstable." The
clue here is "risky and unstable"...

The article also says: "Warning Office was not designed, and is not safe,
for unattended execution on a server." The clue here is "not safe"...

We're way beyond "not supported" here...
The chief reason for developers proceeding with office server automation
is that microsoft has provided no suitable, cost-effective alternative.
That is completely true. It's also completely irrelevant:
http://www.aspose.com/Products/Default.aspx
I recommend you modify your stance to Office server automation is not
supported.
How about: "Server-side Office automation is not support and not
recommended because it is unsafe, risky and unstable due to the fact that
Office was not designed to be used in this manner"...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net


Oct 24 '07 #16

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1142
by: Colby | last post by:
The 2003 net upgrade wizard can not handle migration of MS datareports (VB version 6 DSR) to crystal reports version 9.x RPT. How do you migrate MS datareports to crystal reports? Thanks for your help.
3
2975
by: Inbox.Mirror.Orbisoft | last post by:
In the last 1-3 weeks, we have had numerous users of Task Manager 2007 (www.orbisoft.com) complain that they can no longer export certain reports (Task Manager 2007 uses a Sagekey.com Access 97 runtime) to Excel 2003 or Word 2003 format. They say they get an error message then both Task Manager 2007 and Office 2003 shut down. Any ideas why this is happening?
0
1808
by: Inbox.Mirror.Orbisoft | last post by:
In the last 1-3 weeks, we have had numerous users of Task Manager 2007 (www.orbisoft.com) complain that they can no longer export certain reports (Task Manager 2007 uses a Sagekey.com Access 97 runtime) to Excel 2003 or Word 2003 format. They say they get an error message then both Task Manager 2007 and Office 2003 shut down. Any ideas why this is happening?
0
4137
by: Bill Fallon | last post by:
I am developing a VB.Net application with VS 2005 that opens an Excel workbook and populates the worksheet with data. I started developing the application with Office 2007 installed on my Vista OS, but after I discovered that it won't run on a system with Office 2003, I uninstalled Office 2007 and installed Office 2003. I reset the reference in .Net to the Microsoft Excel 11.0 Object Library. The application works fine from the ..Net...
0
1721
by: silverear | last post by:
Hello everybody, I have written an application that is running as an Office project within Excel in C#. I created a setup project for my tool. When I install my program on a machine that has Excel 2003 everything is fine. If there is only Excel 2007 the installation will fail. If there are both (Excel 2003 and 2007) installed, the installation is also ok. My tool is running fine with Excel 2007, but I can't install it on a machine...
0
1298
by: rockdc1981 | last post by:
I Recently Upgraded My Ms Office To 2007 From 2003, And Very Much Frustrated Finding Out That I Cannot Export My Reports To Excel File..any Help With This Guys?im Thinking Of Possibly Selecting A Report From A Combo Box And Inserting A Command Button That Will Export The Report To Excel File..any Help Or Suggestion Is Appreciated ...tnx In Advance
4
4270
by: Wayne | last post by:
I have an Office 2003 database with custom menu bars that work fine under Access 2007 with the following exception. The Officelinks menu item, "Analyze it with Microsoft Office Excel" is grey out and won't work. Does anyone know why this is and what my options are. I'd much rather stick with the menu bar rather than revert to 2007's Ribbon.
1
1219
by: =?Utf-8?B?U3RlcGhhbmU=?= | last post by:
Hello I would like to know if it is possible to return to MS Excel 2003 after you have upgraded to MS Excel 2007? Here below is what occured. 1. I installed MS Office Home and Student 2007 onto my computer. 2. I no longer see Excel 2003 in my list of programs to choose from,(I had it before). 3. The "Ad-ins" I use do not work with MS Excel 2007 so I would like to go
9
3271
by: AGP | last post by:
I have a VB6 application that has an OLE container with an embedded Excel chart. Our office updated to Excel 2007 and now although the app works the charts looks like crap. Since the app is fairly large my goal is to keep the devlopement in VB6 but am open to any ideas or suggestions. What i want to do is: 1. Keep my app in VB6 and find a workaround for the crappy looking charts. the charts now look very blocky and the grid lines and...
0
9682
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10870
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10563
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10621
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10267
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7804
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6998
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4474
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3123
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.