LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.setup
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error Publishing PivotTable to MOSS. MikeM Charts and Charting in Excel 2 November 16th 07 07:45 PM
How to transpose formulas from column content to row content. Notrom Excel Worksheet Functions 1 October 12th 06 06:57 PM
Posting/publishing to the web ynissel Excel Discussion (Misc queries) 0 June 8th 05 03:24 PM
iNTERACTIVE EXCEL FILE NOT INTERACTIVE ON THE WEB kathy in kansas Excel Discussion (Misc queries) 0 January 24th 05 07:47 PM
Publishing to web Phil Excel Worksheet Functions 0 November 20th 04 07:20 PM


All times are GMT +1. The time now is 08:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"