[mso] Re: Linked Spreadsheet Excel 2003
- From: Wilson Baptista Junior <maninhowilson@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Wed, 05 Dec 2012 12:11:18 -0200
Jim, we need a bit more information to be able to help. Please tell me whether
I got things right:
I understand that you have a workbook, let's call it the "formula" workbook,
which you use to produce the "cut sheets" using data from a "quotes" workbook
which changes from time to time. You send your customer only the "cut sheets"
produced by the formula workbook, you do not send them either the whole
"formula" workbook or the "quote" workbook. Is that right?
Assuming it is;
Both workbooks are designed to work together in the same directory.
When you say that "someone calls up an archived quote", this means one of the
people in your company uses the "formula" workbook to look at the results for
older quotes, which are stored on the S: drive and then saves the "formula"
workbook, which means it now keeps the links to the older "quote" workbook in
drive S:?
If so, one possible solution would be to make your "formula" workbook "read
only", and protect it with a password, or, alternatively, to turn it on an
Excel template. This way it would never be saved (under the same name and
location) with the updated links, and would always retain the links to the P:
drive. Of course that would mean, also, that to make any modifications to its
formulas or layout the person doing the modifications would have to be one
entrusted with the password.
Wilson
At 06:49 05/12/2012 -0600,Jim Hickey wrote:
>The files are all located on the P: drive and the link is specified as
>P:\Costs\ When I move it to archive on the S: drive the link changes to
>S:\Costs\ and I want it to stay P:\Costs\.
>
>Hope that explains it.
>
>Jim
>> ----- Original Message -----
>> From: "Jim Hickey" <jim@xxxxxxxxxxx>
>> To: "Microsoft Office" <mso@xxxxxxxxxxxxx>
>> Sent: Wednesday, December 05, 2012 3:04 AM
>> Subject: [mso] Linked Spreadsheet Excel 2003
>>
>>
>>> We have a pricing spreadsheet that we use that has many formulas and cut
>>> sheets that we send to customers. We have another spreadsheet where we
>>> save
>>> our costs and update as needed. Every six months or so we archive the
>>> quotes from drive "P:" to drive "S:". That way the folders don't get
>>> overloaded with older quotes. When someone calls up an archived quote
>>> and
>>> updates the links excel cannot locate the cost file on the "P:" drive and
>>> ask the user to change the linked file location.
>>> Is there anyway to make this link work on the archived files? Its
>>> location
>>> has NOT changed in more than 5 years. Everyone has the P: and S: drives
>>> mapped in windows. All machines are Windows XP using excel 2003 with all
>>> patches and service packs installed.
>>>
>>> TIA for any help.
>>>
>>> Jim
>>>
>>>
>>> *************************************************************
>>> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
>>> or
>>
>>> MicrosoftOffice@xxxxxxxxxxxxxxx.
>>>
>>> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>>>
>>> To Unsubscribe from this group, visit the group's homepage and use the
>>> dropdown menu at the top. This will allow you to unsubscribe your email
>>> address or change your email settings to digest or vacation (no mail).
>>> //www.freelists.org/webpage/mso
>>>
>>> To be able to share files with the group, you must join our Yahoo sister
>>> group. This group will not allow for posting of emails, but will allow
>>> you to join and share problem files, templates, etc.:
>>> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
>>> FILE SHARING ONLY.
>>>
>>> If you are using Outlook and you see a lot of unnecessary code in your
>>> email messages, read these instructions that explain why and how to fix
>>> it:
>>> http://personal-computer-tutor.com/abc3/v28/greg28.htm
>>> *************************************************************
>>>
>>>
>>> -----
>>> No virus found in this message.
>>> Checked by AVG - www.avg.com
>>> Version: 10.0.1427 / Virus Database: 2634/5435 - Release Date: 12/03/12
>>>
>>>
>>
>> *************************************************************
>> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
>> MicrosoftOffice@xxxxxxxxxxxxxxx.
>>
>> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>>
>> To Unsubscribe from this group, visit the group's homepage and use the
>> dropdown menu at the top. This will allow you to unsubscribe your email
>> address or change your email settings to digest or vacation (no mail).
>> //www.freelists.org/webpage/mso
>>
>> To be able to share files with the group, you must join our Yahoo sister
>> group. This group will not allow for posting of emails, but will allow
>> you
>> to join and share problem files, templates, etc.:
>> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
>> FILE
>> SHARING ONLY.
>>
>> If you are using Outlook and you see a lot of unnecessary code in your
>> email
>> messages, read these instructions that explain why and how to fix it:
>> http://personal-computer-tutor.com/abc3/v28/greg28.htm
>> *************************************************************
>>
>> *************************************************************
>> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
>
>> MicrosoftOffice@xxxxxxxxxxxxxxx.
>>
>> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>>
>> To Unsubscribe from this group, visit the group's homepage and use the
>> dropdown menu at the top. This will allow you to unsubscribe your email
>> address or change your email settings to digest or vacation (no mail).
>> //www.freelists.org/webpage/mso
>>
>> To be able to share files with the group, you must join our Yahoo sister
>> group. This group will not allow for posting of emails, but will allow
>> you to join and share problem files, templates, etc.:
>> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
>> FILE SHARING ONLY.
>>
>> If you are using Outlook and you see a lot of unnecessary code in your
>> email messages, read these instructions that explain why and how to fix
>> it:
>> http://personal-computer-tutor.com/abc3/v28/greg28.htm
>> *************************************************************
>>
>>
>> -----
>> No virus found in this message.
>> Checked by AVG - www.avg.com
>> Version: 10.0.1427 / Virus Database: 2634/5435 - Release Date: 12/03/12
>>
>>
>
>*************************************************************
>You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
>MicrosoftOffice@xxxxxxxxxxxxxxx.
>
>To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
>To Unsubscribe from this group, visit the group's homepage and use the
>dropdown menu at the top. This will allow you to unsubscribe your email
>address or change your email settings to digest or vacation (no mail).
>//www.freelists.org/webpage/mso
>
>To be able to share files with the group, you must join our Yahoo sister
>group. This group will not allow for posting of emails, but will allow you
>to join and share problem files, templates, etc.:
>http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
>SHARING ONLY.
>
>If you are using Outlook and you see a lot of unnecessary code in your email
>messages, read these instructions that explain why and how to fix it:
>http://personal-computer-tutor.com/abc3/v28/greg28.htm
>*************************************************************
>
>*************************************************************
>You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
>MicrosoftOffice@xxxxxxxxxxxxxxx.
>
>To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
>To Unsubscribe from this group, visit the group's homepage and use the
>dropdown menu at the top. This will allow you to unsubscribe your email
>address or change your email settings to digest or vacation (no mail).
>//www.freelists.org/webpage/mso
>
>To be able to share files with the group, you must join our Yahoo sister
>group. This group will not allow for posting of emails, but will allow you to
>join and share problem files, templates, etc.:
>http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
>SHARING ONLY.
>
>If you are using Outlook and you see a lot of unnecessary code in your email
>messages, read these instructions that explain why and how to fix it:
>http://personal-computer-tutor.com/abc3/v28/greg28.htm
>*************************************************************
www.conversasdomano.blogspot.com
--------------------------------------------------------------
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxx.
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister group.
This group will not allow for posting of emails, but will allow you to join
and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
