we are just starting to use OpenOffice ... and have a security issue / problem
we have 12 individual spreadsheets that are submitted by individuals with our organization ... these spreadsheets are password protected to open. at corporate office we have an additonal spreadsheet that extracts (via links) info from those 12 individual spreadsheets. in Excel when we open the Corporate spreadsheet and respond that we wish to update the linked data ... we are prompted for the 12 individual passwords related to the 12 individual spreadsheets. in OpenOffice we are currently not prompted for the passwords to open the 12 individual spreadsheets and all linked cells are displayed with a #REF error. Is this function possible and now do we set the corporate spreadsheet to prompt for the 12 passwords if we are indicating to update the linked data. Thanks in advance for your response. Andy Thompson Tommy's Tanning, Inc
