Solved

Strict Parse Error Excel

Posted on 2014-09-22
5
2,361 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

635 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