Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2657
  • Last Modified:

Strict Parse Error Excel

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
stlhost
Asked:
stlhost
  • 3
  • 2
1 Solution
 
Glenn RayExcel VBA DeveloperCommented:
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
 
stlhostAuthor Commented:
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
 
stlhostAuthor Commented:
Figured it out. Our McAfee gateway is click protecting a link inside the file so it is altering it the code.
0
 
Glenn RayExcel VBA DeveloperCommented:
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
 
stlhostAuthor Commented:
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!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now