SIMS reports in Excel 2016

[datadan]

Hi all

 

Just wondered if anyone else had come across this or if anyone had a fix? If a user has something open in Excel 2016 and then runs a SIMS report that outputs to Excel, the report opens and in effect hides every other Excel window. They go from the taskbar, the names can be seen on the 'switch windows' button in Excel but clicking them doesn't do anything. The only way to get them back is to close Excel and re open them.

 

Obviously this is very frustrating when trying to copy data between spreadsheets.

 

Thanks

[Seb1780]

I too have seen this; no idea of a fix and nothing on SIMS My Account

[RootsSchImp]

(imperfect) workaround rather than a fix but have you tried switching to CSV as the report output?

[datadan]

A solution from another forum so I take no credit for this - comment out the line of VBA in ReportDAta.xls that is visibilty=false.

[WayTooTricky]

The "Visibilty=false" thing sorted me out too. Such a relief to find a fix.

[SJT]

Hi, can you explain (for someone who doesn't do these things) how to 'comment out the line'?

Thanks

[DJ-1701]

Hi, can you explain (for someone who doesn't do these things) how to 'comment out the line'?

Thanks

 

Use an apostrophe before the text.

 

' Other text here.

 

https://www.excel-easy.com/vba/examples/macro-comments.html

[SJT]

Thank you very much.

[eddyc]

A solution from another forum so I take no credit for this - comment out the line of VBA in ReportDAta.xls that is visibilty=false.

 

 

Hi Dan

 

Which ReportData.xls did you do this in please? I am not having any joy getting this to work here.

 

Cheers

[mitchell1981]

Can anyone provide the exact path to this ReportData.xls file? I've run a search on our entire Sims server and it's not anywhere as far as I can tell.

 

It does exist in users Documents Folders in the tempSimsRpt folder, but that is just the data for the most recently run report so changes every time.

 

Thanks.

[RootsSchImp]

Can anyone provide the exact path to this ReportData.xls file? I've run a search on our entire Sims server and it's not anywhere as far as I can tell.

 

It does exist in users Documents Folders in the tempSimsRpt folder, but that is just the data for the most recently run report so changes every time.

 

Thanks.

 

I think it accesses a local copy stored on the machine running SIMS - could be wrong about that tho, is @matt40k about, I bet he knows

[WayTooTricky]

It is the one in the tempSimsRpt folder - you need to open the VBA code.

 

Edited September 25, 2019 by WayTooTricky

[KealeyA]

Hi

 

I have just searched through my ReportData.xls file and that string 'visibility=false' doesn't exist but there are two 'Application.Visible = False'. Are these to be commented out and if so one or both?

[blueday]

I've found that although you can't switch to them, if you choose Arrange all on the View tab, then they do appear...

[blueday]

If you do want to fiddle with the code, I'd also recommend replacing the 'Application.Visible = False' line with 'Application.ScreenUpdating = False' (put it back to True at the end).

[S1F1]

I had this same issue and was advised to replace the tempSimsRpt Folder (and contents) with a clean version. This worked for me.

[Esteban_Child_of_the_Sun]

We had this a while ago. If memory serves me correctly we resolved it by changing the behavior of Excel to open a new instance of Excel for each document rather than re-use the open one.

[coolhands]

Hi I deleted my tempSimsRpt folder and it should apparently re-generate when you next open sims and run a report. However mine has not. Why is it not coming back? Anything I can do? If I run a report it still works, but I just don't know where this folder is if not in the same place as where I deleted it from. Ite was in "C:\Users\Administrator\Documents" for me.

 

edit: I put it back from the recycle bin. But anyone know how I can follow the instructions below?

 

I followed these instructions:

Article: KB0022872

DescriptionWorkAroundSolution

[TABLE=class: ng-scope, width: 100%]

[TR]

[TD]Reporting - Microsoft Excel documents closing when excel reports are run out of SIMS[/TD]

[/TR]

[TR]

[TD]-F1T8F4[/TD]

[/TR]

[TR]

[TD]When a user has a Excel document open and then runs a report out of SIMS that outputs to Excel the original document closes down.[/TD]

[/TR]

[TR]

[TD]See Solution[/TD]

[/TR]

[TR]

[TD]This issue is now resolved with the 7.194 release of SIMS.net. You may find that the issue persists following the upgrade, in the event of this please see below:

 

• Ensure SIMS.net is closed.
  
• Delete the "tempSimsRpt" folder. This can be found within the users Documents folder or a path similar to C:\ Users \ \ Documents \ tempSimsRpt.
  
• Following this when SIMS.net is reopened and a report is run this folder will repopulate.
  

You should now find that previously open Excel documents no longer close when running SIMS.net reports.[/TD]

[/TR]

[/TABLE]

Edited October 8, 2020 by coolhands