[sims] Same report keeps opening from sims. I don't like the way it was fixed.

[browolf]

This situation randomly started happening on an office person's computer.

 

Every time they did a sims report, excel opens a different report. The same different report every time.

 

The tempSimsRpt folder is in documents which is synchronised to one drive.

 

There's a file in here called reportdata.xls where sims writes the report. If I delete this file and create a blank file, sims still writes the wrong report into the file.

 

Our sims support provider took 2 weeks before someone figured out how to fix it by unticking this option in Onedrive settings "use office applications to sync office files I open.

 

This setting is in a section called "file collaboration".

 

I've no idea why this works but disabling file collaboration can't be the best answer?

[dsmith8]

This situation randomly started happening on an office person's computer.

 

Every time they did a sims report, excel opens a different report. The same different report every time.

 

The tempSimsRpt folder is in documents which is synchronised to one drive.

 

There's a file in here called reportdata.xls where sims writes the report. If I delete this file and create a blank file, sims still writes the wrong report into the file.

 

Our sims support provider took 2 weeks before someone figured out how to fix it by unticking this option in Onedrive settings "use office applications to sync office files I open.

 

This setting is in a section called "file collaboration".

 

I've no idea why this works but disabling file collaboration can't be the best answer?

 

We've found this is where OneDrive syncs and caused SIMS to freak a little.

 

We've made a login script that deletes the My Sims Documents and TempSimsRpt on login tends to resolve it most of the time.

 

I've had to use short paths as Powershell does not like spaces so just check your locations by using dir /x in command line. I've also had to move the folder from OnedDive to another location then delete in our case I used AppData this is because the OneDrive Folder does not like Remove-Item query's.

 

Here's our script:

 

Move-Item $home\ONEDRI~1\Documents\TEMPSI~1 $home\appdata\

 

Remove-Item $home\appdata\TEMPSI~1 -Recurse -Force

 

;

 

Move-Item $home\ONEDRI~1\Documents\MYSIMS~1 $home\appdata\

 

Remove-Item $home\appdata\MYSIMS~1 -Recurse -Force

 

 

Hope that is of some use.

Edited February 11, 2021 by dsmith8