There was a problem loading the comments.

SIMS fails to load report or shows information from previous report

Support Portal  »  Knowledgebase  »  Viewing Article

  Print
In some situations, reports run from SIMS may behave oddly such as loading information from a previous report rather than the selected report, or receiving errors in Word or Excel when opening, similar to the following image:
bee3aa5842b027e8587b63ed2a06ec6739f64ed7a714287ef2bdbb1d55c947bbafe6b93df668b336?t=fe34443819e387425d51e6b7e611b6a8
This is due to OneDrive's interoperability with MS Office, forcing MS Office applications to connect to the online version of files in the user's documents folder (online location) instead of the files on disk (physical/local location).
This causes an issue for macros inside the templates SIMS uses. The report will attempt to access the user’s tempSimsRpt folder to get the data needed to compile the report, however instead of being able to access the local version (C:\Users\<username>\Documents\tempSimsRpt) it will instead be passed an online location (https://<School-Name>.sharepoint.com/<user
folder>/documents/tempSimsrpt) which the macros are unable to handle.

The way round this is to disable this interoperability which will then allow the macros to work as expected. To do this first open OneDrive and go to Settings:
3b5e4e46a9f4ce3338d5a7fc11934ea000d39352a72d9a928e5e67503c2426ac61e9399a726fe387?t=c0ee9a7a678b5b9264b8f2ad52321edf
Once in Settings, go to the Office tab and uncheck the tick box "Use Office applications to sync Office files that I open":
f2fb203f28c0b70953f1221ee8ebf3b9e1c2662fdd6d8a00775ae36b302d9a71b4e279ba6ea5532b?t=e3a6ea9dd16326fbf85cc06cbe70bd39


Once unchecked, close any Word/Excel windows and re-run the report. This should now output correctly.

Share via

Related Articles


Self-Hosted Help Desk Software by SupportPal
© Limehurst Academy IT Services