MIS Systems Thread, Excel 2010 Report - Runs, closes, opens blank in Technical; Just had a really strange issue in a supported school. They are using Office 2010 and are running an Excel ...
6th September 2011, 02:48 PM #1
Excel 2010 Report - Runs, closes, opens blank
Just had a really strange issue in a supported school. They are using Office 2010 and are running an Excel report from SIMS that appears to run fine, however when Excel loads, the data gets populated into the worksheet as per normal, then about a second later, Excel shuts down, then reopens again straight to a blank workbook! I've found a work around by enabling the "go straight to print preview" mode when designing the report. This produces the data within the workbook as normal, and print preview loads almost instantly with all the data visible. Close print preview and the report remains open and you can look through the report.
Anyone encountered this at all? :S
IDG Tech News
6th September 2011, 07:37 PM #2
Is the following of relevance from 'Solution Search' on SupportNet? :-
KB30664 - When a report is run to Excel the output is BLANK - SIMS .net Reporting
Thanks to Sivadam from:
Rawns (7th September 2011)
6th September 2011, 10:46 PM #3
Check to see if there is any VB code in the spreadsheet. Had this problem before from an old spreadsheet when moving from 2003 to 2007 back in the day.
7th September 2011, 07:03 AM #4
It's unlikely to be MACRO security if it runs and puts the data out, but as Graham said, could be something in the Macro causing it to reopen Excel. Try refreshing the report using a blank template.
The only other time i've seen similar is when Excel is crashing, but you usually get an error message to say it needs to shut down and has a tick box to say recover / reopen Excel after. If that was running in silent it could cause the issue.
7th September 2011, 08:56 AM #5
Thank's for the pointer but Macro settings are already set to "Enable All".
Originally Posted by Sivadam
I'l take another look at the report but it's strange as it's only pulling out standard staff info from SIMS and outputting it to the standard Excel Portrait output.
By DeeGee in forum Office Software
Last Post: 13th December 2011, 12:35 PM
By Perins in forum Office Software
Last Post: 17th March 2011, 12:25 PM
By Reaper in forum Office Software
Last Post: 1st February 2011, 09:46 AM
By ful56_uk in forum Office Software
Last Post: 31st December 2010, 12:04 PM
By Homer in forum Windows 7
Last Post: 9th September 2010, 12:31 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)