- 6 Posts
- 500 Views
Hi- are there any solutions for having the PS Query Viewer/Manager default to producing files in the newer .xlsx format? Thanks!
Good question, Shama. I've not heard of any way to default PS Query output to the newest Excel format. So we let PeopleSoft do the initial export to Excel as-is. Then, if users want their to be file stored in the newest version of Excel, they simply override that during the Save-As step. (When "Save as" window appears, click Save as type drop-down and change Excel 97-2003 Workbook to Excel Workbook. I admit it's an extra step, but fortunately it's pretty quick.
My hunch is that Oracle was originally supporting organizations who were on older versions...and years later, it's just deemed lower value to upgrade that than all the other things people want fixed/enhanced.
University of Minnesota HRMS