Is it possible to export to Excel without saving the file?
Actually that isn’t true. SmartList creates a file in your %temp% folder and writes to that. Then it opens Excel and displays it. That’s why when you just close Excel, it doesn’t prompt you to save it at all since it was already saved (unless you modify the opened excel file of course).
The only difference is that SmartView always prompts you to set a filename and then writes to that instead.
Currently there isn’t a provision to “export the file to a temp filename” like SmartList does in SmartView. But you can enter as a suggestion here:
Thank you for the “technical” correction. Nevertheless, Smartview requires that the user EXPLICITLY AND MANUALLY provide a unique name to save the file and save the file before you can look at it. Then afterwards the user has to EXPLICITY AND MANUALLY delete the file. None of these actions are needed for Smartlist Excel export. This is tedious and makes the product less “user-friendly”.
If you would like to submit an answer or comment, please sign in to the eOne portal.