Excel export issues
Posted: Sat Apr 11, 2020 11:02 am
Yesterday smartPLS vs 3.2.9 started to fail all excel export (but report, and HTMl or R exports work fine even saved to the same directory used to excel export).
It was very estrange because I was working with the same models and datasets than previous days (when all worked perfectly and I saved a lot of excel exports without any problem).
When I click on excel export I can see the file name dialogue box, and the process starts as always, but a few seconds later the pop-up windows closes without any file saved and no error message appear (but nothing was saved).
It doesn't matter if the results to export are large or not (it fails even exporting a very simple pls model that normally takes less than 600 kb in my hard disk) -I just exported one day ago files as large as 150 000 KB without problems-.
The only thing that I did differently before the first error, was to run a very huge bootstrap procedure with ten groups of 150 cases each (I was working with similar bootstraps with 5 groups of 300 cases without any problem). Just after that no one excel exports works for me, even if I restarted the program. I have shut down the computer and start new session from scratch (but the problem still arises).
I do not know if any hidden file can "remember something" that prevent excel export to work fine. Excel export are necessary because I work with multiple imputation procedure and I need to extract the results with formulas in order to perform the final calculations easily (instead to use manual copy and paste that is prone to errors).
Best regards,
It was very estrange because I was working with the same models and datasets than previous days (when all worked perfectly and I saved a lot of excel exports without any problem).
When I click on excel export I can see the file name dialogue box, and the process starts as always, but a few seconds later the pop-up windows closes without any file saved and no error message appear (but nothing was saved).
It doesn't matter if the results to export are large or not (it fails even exporting a very simple pls model that normally takes less than 600 kb in my hard disk) -I just exported one day ago files as large as 150 000 KB without problems-.
The only thing that I did differently before the first error, was to run a very huge bootstrap procedure with ten groups of 150 cases each (I was working with similar bootstraps with 5 groups of 300 cases without any problem). Just after that no one excel exports works for me, even if I restarted the program. I have shut down the computer and start new session from scratch (but the problem still arises).
I do not know if any hidden file can "remember something" that prevent excel export to work fine. Excel export are necessary because I work with multiple imputation procedure and I need to extract the results with formulas in order to perform the final calculations easily (instead to use manual copy and paste that is prone to errors).
Best regards,