Thanks Paul,
Have now found the setting in the workbook that does cause the issue.
In the xls provided, a checkbox was selected at MenuToolsShare
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.aumailto:jason.si...@dws.com.au W:
www.dws.com.auhttp://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.aumailto:jason.si...@dws.com.au W:
www.dws.com.auhttp://www.dws.com.au/
DWS ADVANCED BUSINESS SOLUTIONS
___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss