473,698 Members | 2,635 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 #1
15 5348
"shashank kulkarni" <sh************ **@discussions. microsoft.comwr ote in
message news:6A******** *************** ***********@mic rosoft.com...
Could any one come across this difficulty / Issue?
Firstly, server-side Office automation is not supported by Microsoft because
it doesn't work properly - Office just wasn't designed to be run in this
type of environment.

Secondly, you can't just install Office on a webserver because of licensing
issues...
Please Suggest appropriate solution if any one knows.
http://www.aspose.com/Products/Aspos...s/Default.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 5 '07 #2
Hi,

We are using license copy of Excel 2007 (Office 2007 ) :)

Our Project Environment is Like this

1) Web application (Asp.Net 1.1) hosted on windows 2003 server
2) Database is Sql 2000 server
3)This is reporting Application --- reports are genrated using OWC (Office
web component) and also using custom logic which draws flow chart on Excel.
4) Currently in production We are using Office 2003 (Excel 2003 )Client
Requirement is like that to upgrade it to Office 2007 (Excel 2007)
5) We need to upgrade Office 2003 to Office 2007
7) When we do this OWC in built functionality works properly but stops
custom excel download fucntionality (Drawing flow Chart)
8) But same thing works fine when we just install Excel 2007 with out
upgrading

Could you please put some more highlight on the issue if you find some thing .

Thanks in advance

Regards
Shashank P Kulkarni
"Mark Rae [MVP]" wrote:
"shashank kulkarni" <sh************ **@discussions. microsoft.comwr ote in
message news:6A******** *************** ***********@mic rosoft.com...
Could any one come across this difficulty / Issue?

Firstly, server-side Office automation is not supported by Microsoft because
it doesn't work properly - Office just wasn't designed to be run in this
type of environment.

Secondly, you can't just install Office on a webserver because of licensing
issues...
Please Suggest appropriate solution if any one knows.

http://www.aspose.com/Products/Aspos...s/Default.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 5 '07 #3
"shashank kulkarni" <sh************ **@discussions. microsoft.comwr ote in
message news:A5******** *************** ***********@mic rosoft.com...
3)This is reporting Application --- reports are genrated using OWC
(Office
web component) and also using custom logic which draws flow chart on
Excel.
There was no mention of OWC in your original post...

However: http://blogs.msdn.com/excel/archive/...17/668544.aspx

Specifically, paragraph 3:

"Microsoft has shipped different versions of OWC in the last three releases
of Microsoft® Office, including Microsoft Office 2003, Microsoft Office XP,
and Microsoft Office 2000, however, the Office Web Components will not ship
with the 2007 Microsoft Office system. The version of OWC that shipped with
the 2003 release of Microsoft Office will be the last revision to this
technology. Additionally, the ability to author OWC-based web pages is also
being removed from Microsoft Office 2007 applications such as Microsoft
Office Excel® 2007 and Microsoft Office Access 2007, and OWC will not ship
with Microsoft Office SharePoint® Designer 2007, which is partially based on
Microsoft Office FrontPage® 2003. Though they will not be updated, the
components will ship with Microsoft Office Project Server 2007."
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 5 '07 #4
for office Web component it is working properly even after upgrading from
Excel 2003 to Excel 2007.
But there are reports which we write using excel object. Like draw some
Flights (Calendar in cells of work book Like this)

Jan feb March April May ............... ...........

TV ............
Such type of functionality we are providing in this custom excel report .
We are creating XML file to write this data and then convert it to .xls file .
All .xml files created at run time on the server.
This report gives us problem after upgrading to office 2007 :(

Thanks
Shashank

"Mark Rae [MVP]" wrote:
"shashank kulkarni" <sh************ **@discussions. microsoft.comwr ote in
message news:A5******** *************** ***********@mic rosoft.com...
3)This is reporting Application --- reports are genrated using OWC
(Office
web component) and also using custom logic which draws flow chart on
Excel.

There was no mention of OWC in your original post...

However: http://blogs.msdn.com/excel/archive/...17/668544.aspx

Specifically, paragraph 3:

"Microsoft has shipped different versions of OWC in the last three releases
of Microsoft® Office, including Microsoft Office 2003, Microsoft Office XP,
and Microsoft Office 2000, however, the Office Web Components will not ship
with the 2007 Microsoft Office system. The version of OWC that shipped with
the 2003 release of Microsoft Office will be the last revision to this
technology. Additionally, the ability to author OWC-based web pages is also
being removed from Microsoft Office 2007 applications such as Microsoft
Office Excel® 2007 and Microsoft Office Access 2007, and OWC will not ship
with Microsoft Office SharePoint® Designer 2007, which is partially based on
Microsoft Office FrontPage® 2003. Though they will not be updated, the
components will ship with Microsoft Office Project Server 2007."
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 5 '07 #5
"shashank kulkarni" <sh************ **@discussions. microsoft.comwr ote in
message news:9A******** *************** ***********@mic rosoft.com...
This report gives us problem after upgrading to office 2007 :(
I'm afraid I don't really know enough about OWC to be of much more help -
have you tried posting in microsoft.publi c.excel?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 5 '07 #6
i did post this ??? in microsoft.publi c.excel forum :) already

thanks Mark for your quick response
"Mark Rae [MVP]" wrote:
"shashank kulkarni" <sh************ **@discussions. microsoft.comwr ote in
message news:9A******** *************** ***********@mic rosoft.com...
This report gives us problem after upgrading to office 2007 :(

I'm afraid I don't really know enough about OWC to be of much more help -
have you tried posting in microsoft.publi c.excel?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 5 '07 #7
You simply need to re-register the OWC component using a command prompt.
That should fix your problem. Your problem isn't related to Office 2007. OWC
is stand-alone because it is statically built and doesn't depend on any
Office product for functionality.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless Author Plug
OWC Black Book 2nd Edition
Exclusively on www.lulu.com/owc
$24.99
"shashank kulkarni" <sh************ **@discussions. microsoft.comwr ote in
message news:CF******** *************** ***********@mic rosoft.com...
>i did post this ??? in microsoft.publi c.excel forum :) already

thanks Mark for your quick response
"Mark Rae [MVP]" wrote:
>"shashank kulkarni" <sh************ **@discussions. microsoft.comwr ote in
message news:9A******** *************** ***********@mic rosoft.com...
This report gives us problem after upgrading to office 2007 :(

I'm afraid I don't really know enough about OWC to be of much more help -
have you tried posting in microsoft.publi c.excel?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net


Oct 6 '07 #8
On 6 Pa, 04:16, "Alvin Bruney [MVP]" <some guy without an email
addresswrote:
You simply need to re-register the OWC component using a command prompt.
That should fix your problem. Your problem isn't related to Office2007. OWC
is stand-alone because it is statically built and doesn't depend on any
Office product for functionality.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless Author Plug
OWC Black Book 2nd Edition
Exclusively onwww.lulu.com/owc
$24.99

"shashank kulkarni" <shashankkulka. ..@discussions. microsoft.comwr ote in
messagenews:CF* *************** *************** ***@microsoft.c om...
i did post this ??? in microsoft.publi c.excelforum :) already
thanks Mark for your quick response
"Mark Rae [MVP]" wrote:
"shashank kulkarni" <shashankkulka. ..@discussions. microsoft.comwr otein
messagenews:9A* *************** *************** ***@microsoft.c om...
This report gives us problem after upgrading to office2007:(
I'm afraid I don't really know enough about OWC to be of much more help -
have you tried posting in microsoft.publi c.excel?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net- Ukryj cytowany tekst -

- Poka cytowany tekst -
Hey

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".

thank you in advance for any clue
regards
Gorgo

Oct 18 '07 #9
"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 18 '07 #10

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

Similar topics

0
1135
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
2959
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
1798
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
4128
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
1714
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
1295
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
4264
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
1216
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
3251
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
8610
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
9170
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...
1
8902
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
8873
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
6528
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
4372
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4623
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3052
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
2
2339
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.