PCM.daily banner
06-12-2025 05:30
PCM.daily
Users Online
· Guests Online: 35

· 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 worksheet setting error fix
DaveTwoBob
Top  #1 Print Post
Posted on 25-02-2014 14:11
Sometimes when you try to open your exported results in Excel it won't do it and gives you a Worksheet Setting error.

Searching the forums I found CountArach suggested using OpenOffice as this opens the troublesome files OK.

I did a bit of googling and found a fix.

The issue is when a race has 200 riders. PCM creates a table with 200 rows but forgets to add one for the headers <doh>.

You can fix this by making the row count 201 or greater. I used 210 for a bit of wriggle room. Heres how:

Start Notepad and open the export file (change to All Files view to see them).
You will see lots of XML code, thats OK. First line will look like this.
<?xml version="1.0" encoding="UTF-8"?>

Choose Edit>Replace from the menu

Find What: ExpandedRowCount="200"
Replace With: ExpandedRowCount="210"

Click Replace All (there are 6 entries) then close the replace window

File>Save As a new name and it should now open OK in Excel (you still get the annoying file in different format message though).

My setup is Excel 2007 and Windows 8.1 using English Language but I think this should work with other setups.

Hope this helps someone.
Manager of Renault Classic [ICL]
Manager of Kraftwerk Man Machine [Man Game]
 
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
London row houses
London row houses
PCM14: 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.26 seconds
Copyright © 2006-2023


Powered by PHP-Fusion Copyright © 2025 PHP-Fusion Inc
Released as free software without warranties under GNU Affero GPL v3