Home |
Search |
Today's Posts |
#1
![]()
Posted to 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 |
#2
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
Hi Jeff,
Hi , I would appreciate it if you could drop me a note to let me know the status of the issue in the thread. If you have any questions or concerns, please feel free to let me know. I am happy to be of assistance. :) -------------------- By the way, I will be out of office during Jan 28th to Feb 5th. If you have any reply, please reply to the newsgroup and my backup engineer will reply you as soon as possible. In addition, if you need to send log files/screen shots via emails, please email it to the address . Thanks for your understanding. -------------------- Sincerely, 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 this issue. ================================================== ==== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- X-Tomcat-ID: 200382916 References: MIME-Version: 1.0 Content-Type: text/plain Content-Transfer-Encoding: 7bit From: (Emily Lin) Organization: [Microsoft] Date: Wed, 23 Jan 2008 10:07:09 GMT Subject: Error Publishing Interactive Content X-Tomcat-NG: microsoft.public.excel.setup Message-ID: Newsgroups: microsoft.public.excel.setup Lines: 69 Path: TK2MSFTNGHUB02.phx.gbl Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.excel.setup:2224 NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Publishing PivotTable to MOSS. | Charts and Charting in Excel | |||
How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
Posting/publishing to the web | Excel Discussion (Misc queries) | |||
iNTERACTIVE EXCEL FILE NOT INTERACTIVE ON THE WEB | Excel Discussion (Misc queries) | |||
Publishing to web | Excel Worksheet Functions |