Exported Results Error
|
baseballlover312 |
Posted on 07-04-2014 20:44
|
Tour de France Champion
Posts: 16452
Joined: 27-07-2011
PCM$: 10538.70
|
I've tried to export results, but every time I open up my Fleche results or Liege results I get a "Worksheet Settings" error. I've tried multiple computers with no change. This only applies to those two results, one's I exported before Fleche show no issue at all. It is vital for me to be able to do this going forward.
Here's the error:
XML ERROR in Worksheet Setting
REASON: Bad Value
FILE: C:\Users\"Username"\Documents\Pro Cycling Manager 2013\Users\Pickles312\Export\Exported_results\Liege-Bastogne-Liège_Liège-Liège.xls
GROUP: Worksheet
TAG: Table
ATTRIB: ExpandedRowCount
VALUE: 200
Anybody know what's going wrong and how I can fix it? Any help would be appreciated. Thanks.
RIP Exxon Duke, David Veilleux, Double Feature, and Monster Energy
|
|
|
|
Cycleman123 |
Posted on 07-04-2014 21:00
|
Grand Tour Specialist
Posts: 4478
Joined: 30-07-2012
PCM$: 200.00
|
I don't get the same error, so this might not work, but whenever I get an error message on Excel I just ignore it and everything works fine.
|
|
|
|
Ad Bot |
Posted on 24-12-2024 00:51
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
IP: None |
|
|
baseballlover312 |
Posted on 07-04-2014 21:02
|
Tour de France Champion
Posts: 16452
Joined: 27-07-2011
PCM$: 10538.70
|
I can't ignore it, the file doesn't open.
RIP Exxon Duke, David Veilleux, Double Feature, and Monster Energy
|
|
|
|
Lachi |
Posted on 07-04-2014 23:52
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
As the error says, there is an XML error. Normally this means that one or more characters in the file are not valid.
You could ask google how to open an XLS file with an XML editor. Good XML editors should be able to find and mark all errors, so that you could fix them. But I think it would involve much reading, so I wonder how important these results are for you. |
|
|
|
baseballlover312 |
Posted on 08-04-2014 02:25
|
Tour de France Champion
Posts: 16452
Joined: 27-07-2011
PCM$: 10538.70
|
Well I need them for my story I think it is vital that I fix this issue eventually. I'm just not sure what the difference is between the files that were exported Friday as opposed to now.
Suppose I'll look that up eventually, don't have time now. thank you for your help.
RIP Exxon Duke, David Veilleux, Double Feature, and Monster Energy
|
|
|
|
547984 |
Posted on 08-04-2014 03:01
|
Grand Tour Specialist
Posts: 5008
Joined: 29-01-2013
PCM$: 200.00
|
According to ExpandedRowCount hits on Google, it might have to do with something about the XML value in ss:ExpandedRowCount (which is 200) does not match the number of riders(rows) that are in the file I guess.
Now I don't have a clue on how to edit a XML
baseballlover312, 06-03-14 : "Nuke Moscow...Don't worry Russia, we've got plenty of love to go around your cities"
Sarah Palin, 08-03-14 (CPAC, on Russian aggression) : "The only thing that stops a bad guy with a nuke is a good guy with a nuke"
Big thanks to jdog for making this AMAZING userbar!
|
|
|
|
Kentaurus |
Posted on 08-04-2014 05:57
|
Classics Specialist
Posts: 3999
Joined: 26-07-2011
PCM$: 200.00
|
Try downloading a free spreadsheet program. Either LibreOffice or OpenOffice and see if they work. (Both can handle .xls files)
AZTECA - NBCSN
|
|
|
|
DaveTwoBob |
Posted on 11-04-2014 03:22
|
Small Tour Specialist
Posts: 2436
Joined: 07-07-2013
PCM$: 200.00
|
I have posted a fix here
https://pcmdaily.com/forum/viewthread....d_id=33126
Hope it works for you.
|
|
|
|
baseballlover312 |
Posted on 11-04-2014 03:27
|
Tour de France Champion
Posts: 16452
Joined: 27-07-2011
PCM$: 10538.70
|
Thanks so much! I'll be sure to use this whenever the problem happens again! thanks a bunch for your help!
RIP Exxon Duke, David Veilleux, Double Feature, and Monster Energy
|
|
|