Solved

Strict Parse Error Excel

Posted on 2014-09-22
5
2,035 Views
Last Modified: 2014-10-13
I am assuming this excel file is a report that was converted from another file source but unfortunately getting a hold of the company to get any answers have proven to be extremely difficult. Their support claims we are the only ones who has this problem. When you open this report it pops up with an error Strict Parse Error. Check the log and it shows

XML PARSE ERROR:  Missing whitespace between attributes
  Error occurs at or below this element stack:
    (Stack is empty--error occurs at or below top-level element.)

Unfortunately I am not an excel expert
0
Comment
Question by:stlhost
  • 3
  • 2
5 Comments
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40337136
This appears to be a similar issue to one mentioned in this question here @ EE.

The resolution involved opening the file in Notepad (or any text editor) and checking the XML tags for any bad attributes or layouts.

If you can attach the file, I'd be glad to see if I can locate and resolve the issue.  I have a very good text editor with XML layout recognition.

Regards,
-Glenn
0
 
LVL 2

Author Comment

by:stlhost
ID: 40337182
I would like to but this attachment has names, addresses and phone numbers in it (personal info that I can't release). Anything in the doc relating to XML I can list here if you like. When I search for any xml lines they are spread out but here is what all I can see.


<?xml version="1.0" encoding="iso-8859-1"?>

Open in new window

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
          xmlns:x="urn:schemas-microsoft-com:office:excel"
          xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
          xmlns:html="

Open in new window

<DocumentProperties xmlns="urn:schemas-microsoft-com:office">

Open in new window

<x:WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

Open in new window

0
 
LVL 2

Accepted Solution

by:
stlhost earned 0 total points
ID: 40337638
Figured it out. Our McAfee gateway is click protecting a link inside the file so it is altering it the code.
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40337681
Wow and wierd.  Good catch; never would have guessed that.  

You should probably go ahead and close this question with no solution recognized (well, yours, of course).
0
 
LVL 2

Author Closing Comment

by:stlhost
ID: 40376642
I dont now how else to close this question
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question