RePublish of Excel Service Error

Thu, 09/17/2009 - 16:55
Cap
User offline. Last seen 42 weeks 15 hours ago. Offline
Joined: 09/01/2009
Points: 60

Successfully created and Published an Excel Service.

Successfully created and viewed a mashlet of the Excel service.

Attempted to change one value in one field and then "RePublish worksheet updates to the Excel service".  Got error as seen in attachment.

Actually I don't even have to edit the content.  I also tried a republish on another Excel service that had been successfully published.  I did not edit anything.  I just selected the option.  Got the same error.

Ideas?

0
Your rating: None
Thu, 09/17/2009 - 18:28
Copy comment link
ivan_mejia
ivan_mejia's picture
User offline. Last seen 8 weeks 5 days ago. Offline
Joined: 09/22/2008
Points: 0

Hi, which version of Presto and Presto Excel Connector are you using?

Fri, 09/18/2009 - 10:16
Copy comment link
Cap
User offline. Last seen 42 weeks 15 hours ago. Offline
Joined: 09/01/2009
Points: 60

Presto 2.7.0.  Enterprise Mashup Server says Build 060309

Excel Connector - see attachment

Fri, 09/18/2009 - 10:27
Copy comment link
ivan_mejia
ivan_mejia's picture
User offline. Last seen 8 weeks 5 days ago. Offline
Joined: 09/22/2008
Points: 0

Hi,

Additionally could you tell me which version of Office are you using as well as paste screenshot of the Excel range you are publishing/re-publisning?

Thanks!

Ivan.

Fri, 09/18/2009 - 16:53
Copy comment link
ivan_mejia
ivan_mejia's picture
User offline. Last seen 8 weeks 5 days ago. Offline
Joined: 09/22/2008
Points: 0

Hi,

   I could not reproduce the error in none of the two supported versions of Office: 2003 and 2007. So I would appreciate if you can send the screenshot of the Excel sheet range you are publishing or if possible the Excel file you are using.

Ivan.

Tue, 09/22/2009 - 12:07
Copy comment link
Cap
User offline. Last seen 42 weeks 15 hours ago. Offline
Joined: 09/01/2009
Points: 60

Excel sheet range attached

Tue, 09/22/2009 - 17:17
Copy comment link
ivan_mejia
ivan_mejia's picture
User offline. Last seen 8 weeks 5 days ago. Offline
Joined: 09/22/2008
Points: 0

Ok,

  If you are publishing formulas that could be a problem, we do not support formulas on the cells for now, just data. Can be numbers or text, but not formulas.

Ivan