PCM.daily banner
07-12-2025 17:12
PCM.daily
Users Online
· Guests Online: 43

· Members Online: 0

· Total Members: 54,920
· Newest Member: RodrigueGauthier
View Thread
PCM.daily » Pro Cycling Manager 2006-2020 » Pro Cycling Manager 2013
 Print Thread
Exported Results Error
baseballlover312
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
pcmdaily.com/files/Awards2016/avatar.png
pcmdaily.com/files/Awards2019/funniest.png
pcmdaily.com/images/mg/Awards2020/funniest.png
pcmdaily.com/images/mg/Awards2020/forumthread.png
i.imgur.com/VCXYUyF.png
i.imgur.com/4osUjkI.png
 
Ad Bot
Posted on 07-12-2025 17:12
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
Cycleman123
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.
i1193.photobucket.com/albums/aa348/the_hoyle86/Graphics/Road%20to%20Le%20Tour_zpsnovshuyf.png

i1193.photobucket.com/albums/aa348/the_hoyle86/Graphics/Oricav2_zpsc6257c80.png
 
baseballlover312
I can't ignore it, the file doesn't open.
RIP Exxon Duke, David Veilleux, Double Feature, and Monster Energy
pcmdaily.com/files/Awards2016/avatar.png
pcmdaily.com/files/Awards2019/funniest.png
pcmdaily.com/images/mg/Awards2020/funniest.png
pcmdaily.com/images/mg/Awards2020/forumthread.png
i.imgur.com/VCXYUyF.png
i.imgur.com/4osUjkI.png
 
Lachi
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
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
pcmdaily.com/files/Awards2016/avatar.png
pcmdaily.com/files/Awards2019/funniest.png
pcmdaily.com/images/mg/Awards2020/funniest.png
pcmdaily.com/images/mg/Awards2020/forumthread.png
i.imgur.com/VCXYUyF.png
i.imgur.com/4osUjkI.png
 
547984
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 Frown
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"

i1360.photobucket.com/albums/r657/547984/truth-vi.png

Big thanks to jdog for making this AMAZING userbar!
 
Kentaurus
Try downloading a free spreadsheet program. Either LibreOffice or OpenOffice and see if they work. (Both can handle .xls files)
AZTECA - NBCSN pcmdaily.com/files/Micros16/azt.png
 
DaveTwoBob
I have posted a fix here
https://pcmdaily.com/forum/viewthread....d_id=33126
Hope it works for you.
Manager of Renault Classic [ICL]
Manager of Kraftwerk Man Machine [Man Game]
 
baseballlover312
Thanks so much! I'll be sure to use this whenever the problem happens again! thanks a bunch for your help! Smile
RIP Exxon Duke, David Veilleux, Double Feature, and Monster Energy
pcmdaily.com/files/Awards2016/avatar.png
pcmdaily.com/files/Awards2019/funniest.png
pcmdaily.com/images/mg/Awards2020/funniest.png
pcmdaily.com/images/mg/Awards2020/forumthread.png
i.imgur.com/VCXYUyF.png
i.imgur.com/4osUjkI.png
 
Jump to Forum:
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Top talent Isaak
Top talent Isaak
PCM11: General Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 23,776 PCM$
bullet Marcovdw 20,845 PCM$
bullet df_Trek 19,674 PCM$
bullet jseadog1 17,752 PCM$
bullet baseba... 13,639 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 24,090 PCM$
bullet Marcovdw 20,300 PCM$
bullet df_Trek 17,820 PCM$
bullet jseadog1 17,700 PCM$
bullet Caspi 10,730 PCM$

bullet Main MG Betting page
bullet Get weekly MG PCM$
bullet Rankings: Top 100
Render time: 0.14 seconds