Does anyone know if it's possible to change the version of Excel that reports save as? (I.e. so that it's a one step process to have it as an .xlsx file)
When we save a report to Excel it saves in the 97-2003 .xls format. It would save steps and make certain users thrilled if it were possible to save it as a newer version. I do understand the reasons for it defaulting to the oldest possible, for compatibility.
Thanks!
Stacey Voigt Database Manager Santa Barbara Center for the Performing Arts svoigt@granadasb.org
I'd also be interested in whether this can be made possible - it never used to be a problem for us but then one day we started having to 'save as' and then change the file type every time we exported an excel document from Tessitura.Thanks,James
Hi guys -
It's my understanding from talking to various behind the scenes people that this is not possible right now. I had my fingers crossed for v12, but alas, my dreams did not come true.
If someone knows of magic to make this happen, that would be lovely!
- Heather
I ask staff to save reports as Comma Separated Text (which is actually.csv) then they can go straight into the document (no Protected View!), make cosmetic changes as needed then save as .xlsx.
One idea is that users can continue to save using the same .csv file over and over as long as it is closed so you don't wind up with hundreds of them on the network or PC
Still an added step involved but has cut frustration by more than half.