PCM.daily banner
28-02-2025 01:59
PCM.daily
Users Online
· Guests Online: 33

· Members Online: 0

· Total Members: 163,218
· Newest Member: asierbs
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
Stats, sorted by best sprinter
Stats, sorted by best sprinter
PCM 07: General Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 19,776 PCM$
bullet df_Trek 18,674 PCM$
bullet Marcovdw 16,845 PCM$
bullet jseadog1 14,652 PCM$
bullet baseba... 10,939 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 22,790 PCM$
bullet df_Trek 16,820 PCM$
bullet Marcovdw 16,300 PCM$
bullet jseadog1 14,600 PCM$
bullet baseball... 7,832 PCM$

bullet Main MG Betting page
bullet Get weekly MG PCM$
bullet Rankings: Top 100
Render time: 0.18 seconds
Copyright © 2006-2023


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