Thanks Paul, Have now found the setting in the workbook that does cause the issue.
In the xls provided, a checkbox was selected at <Menu>Tools>Share Workbook>'Allow changes by more than one user at the same time. This also allows workbook merging'. De-selecting this checkbox has resolved the issue. The organisation is using MOSS and Excel 2003 - so this issue may have been resolved in later versions. regards, Ricky Elias Software Consultant P: 07 3221 2858 M: 0420 275 002 F: 07 3221 3812 A: Podium Level 1, 320 Turbot Street, Brisbane QLD 4000 E: ricky.el...@dws.com.au<mailto:jason.si...@dws.com.au> W: www.dws.com.au<http://www.dws.com.au/> DWS ADVANCED BUSINESS SOLUTIONS [X] ________________________________ From: ozmoss-boun...@ozmoss.com [ozmoss-boun...@ozmoss.com] on behalf of Paul Noone [paul.no...@ceosyd.catholic.edu.au] Sent: Wednesday, 9 November 2011 2:47 PM To: ozMOSS Subject: RE: Issue using a Template with a Document Content Type Did you apply the template through the UI at the site collection Content Type level? Have you tried resaving it out as an XLS file with a different name and uploading it again? Could it have been saved as the wrong file type with a macro hidden away in it? From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ricky Elias Sent: Wednesday, 9 November 2011 3:33 PM To: ozmoss@ozmoss.com Subject: Issue using a Template with a Document Content Type Hi, We have created a content type that inherits from Document and the only additional configuration is to provide an Excel file for a template. After adding this content type to a Doc Library, when a user creates a new file, they are immediately promted to 'Save As' the excel file into the folder at /site/doclibrary/Forms/ContentTypeName as 'SDS_Template1.xls' before the new spreadsheet is opened for editing. Note: name of the file uploaded as the template is 'SDS_Template.xls'. Once the file is either saved or the save request is cancelled, the user can edit the new instance of the excel spread and when saved it placed the editied file in the /site/doclibrary/ location as expected, with a default filename of 'SDS_Template1.xls'. The issue only occurs for a specific excel spreadsheet, i.e. if the content type is updated to use a different spreadsheet for the template, then the user is not prompted to save the file into the content type folder each time a new item is created. -has anyone seen or resolved this issue before? I guess it is something specific about the Excel template that was provided to me... but not sure what to look for. regards, Ricky Elias Software Consultant P: 07 3221 2858 M: 0420 275 002 F: 07 3221 3812 A: Podium Level 1, 320 Turbot Street, Brisbane QLD 4000 E: ricky.el...@dws.com.au<mailto:jason.si...@dws.com.au> W: www.dws.com.au<http://www.dws.com.au/> DWS ADVANCED BUSINESS SOLUTIONS
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss