Solved

Strict Parse Error Excel

Posted on 2014-09-22
5
2,133 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

Independent Software Vendors: 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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

762 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