Marksheets: Any way to increase column export limit?

[Paine]

Hi all,I've searched this forum, and done a bit of googling, but can't find the answer to this question (which must have been asked before - so perhaps my search terms aren't very good!).I've been asked to create a 'broadsheet' for KS5 which dumps every subject's data, from every data drop, into a single mark sheet ready for export to Excel.This is just shy of 380 columns, but SIMS tells me this is too large to export to excel.Is there a way around this, or is it an in-built flaw with SIMS?Thanks

[Banjo]

My guess, a limit in SIMS - probably set at 256 and a hangover from the past.

[Esteban_Child_of_the_Sun]

in SIMS.net go to 'Tools | Performance | Options', put a tick in the 'Extended Marksheet Column Limit' (Capita would remind you at this point that ticking this box will stop SIMS working properly with Excel 2003 and earlier version, and this is why they haven't made this a default yet.)

[Paine]

Interesting.. that box is already ticked. Maybe I need to ignore the warning, try exporting, and see what happens?