SIMS Reporting Issue

[qwertyuiop1]

Hi all,

 

Hope everyone is well!

 

I've got a right quirk that's come up with SIMS.net within our organisation...

 

When reports are run and the excel previewer comes up showing the results of the report, Excel launches, shows the report for a split second then immediately closes itself resulting in me not being able to view report data

 

This happens on several machines, using different accounts as well which leads me to think it's some setting within Excel or within SIMS

 

I've tried the following things already, to no avail:

• Move the machines into an OU containing no Office policies
  
• Regenerated the report from scratch
  
• Enabled macros
  
• Reinstall Office
  
• Reinstall Windows
  

 

Still baffled - I must be missing something obvious as it's only been happening for the last couple of weeks

 

Any ideas or suggestions would be greatly appreciated

 

Cheers!

Edited February 3, 2023 by qwertyuiop1

[jthompson]

I've had that on occasions with larger reports. Sometimes relaunching Excel will present some file recovery options, which might get you your report output.

[qwertyuiop1]

I've had that on occasions with larger reports. Sometimes relaunching Excel will present some file recovery options, which might get you your report output.

 

I tried the recovery options within Excel.

 

The report reappears but then crashes again as it goes straight into the "Print Preview" section.

 

I've also changed the default printer to "Microsoft Print to PDF" incase it was an issue with the printer here too

[qwertyuiop1]

I managed to resolve this. Turns out for whatever stupid reason, Authenticated Users permission group was removed off the tempSimsRpt folder.

 

Adding the group back in and assigning it Full Control for the one user seems to have fixed it