View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Emily Lin Emily Lin is offline
external usenet poster
 
Posts: 16
Default Error Publishing Interactive Content

Hi Jeff,

In the XML definition of the Excel spreadsheet, the data validation value =A1*A2 (or another formula) is not supported. Please save the
file as a normal *.xls file instead or replace the data validation value as an exact value (such as 3) instead of a formula.

If anything is unclear or if you have any other concerns, please don't hesitate to contact me.

Regards,

Emily Lin

Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
Thread-Topic: Error Publishing Interactive Content
thread-index: AchdZywjh8N/G4wQRUCkBmIvZTUsVg==
X-WBNR-Posting-Host: 207.46.193.207
From: ?B?SkU=?=
Subject: Error Publishing Interactive Content
Date: Tue, 22 Jan 2008 18:25:08 -0800
Lines: 21
Message-ID:
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
Newsgroups: microsoft.public.excel.setup
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.excel.setup:2222
NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
X-Tomcat-NG: microsoft.public.excel.setup

I have a very simple spreadsheet that I created for my son to practice his
multiplication. The cells thhat he places the product in have validation on
them. The validation is just to allow a whole number equal to =A1*A2. If he
enters an incorrect value, ie; something other than the sum in the
validation, a message is displayed.

I was going to save it as a web page with interactive content, but when I do
and try to run it I get the following error:


----------------------------------------------------------------------------------------------
The Microsoft Office Spreadsheet Component could not load the XML data.

Validation Load Error: In the XML definition of this spreadsheet, the
DataValidation element for Range Whole contains the following error: A value
specified for either the <Min (


----------------------------------------------------------------------------------------------

If you click OK, you get a blank spreadsheet.

Any Help Would Be Greatly Appreciated.
--
JE