Solved

Strict Parse Error Excel

Posted on 2014-09-22
5
1,963 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
conditional formatting 4 43
Excel format formula for currency 15 24
And OR formula 5 23
ProperCase in Excel (Sheet) 3 16
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
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…
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…
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 …

803 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