[mso] Re: Excel behaving badly
- From: "David Grugeon" <david@xxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 2 Dec 2010 14:42:12 +1000
Hi Jens
You are correct that you cannot protect or unprotect a shared workbook. You
have to open it in exclusive mode to change the protection.
The left-over files starting with ~ are from sessions which ended
abnormally. They can be deleted if they relate to an earlier session.
Best regards
David Grugeon
M-0429 029 836
P-(07)3263 7786
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
> Behalf Of Jens.N.Outzen@xxxxxxxxxxxxxx
> Sent: Monday, 29 November 2010 12:16 AM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Re: Excel behaving badly
>
> Thank you VERY much - that was exactly what had happened !
> One other "obscure" even that has happened - in the same workbook - is
> that my "Protection" option has been greyed out.
>
> I have 2 sheets in the workbook (contains 20) that are protected. That is
> where my look-up formulas are, got tired of having to re-enter them
> because people over wrote the formula.
> It is a shared workbook (and its Windows 2003 - company refuses to upgrade
> saying its too expensive. I am considering suggesting OO but that would be
a
> shame). Trying to recall from my early schooling in excel (about 20 years
ago -
> give and take) if you have a shared workbook you cannot effect changes (as
> in un-protecting your workbook) unless you are the only person that has it
> open !?
> Is that the reason or is there another reason for the greying out?
>
> And I seem to have some open sessions hanging in the system......
>
>
> Jens N. Outzen
>
> Lea Interchange Depot
> 0208 988 4700
> 07931 904 611 (Mob)
>
> First Capital North Limited No 0263641
> First Capital East Limited No 02218277
> Registered in England & Wales
> B Block 3rd Floor MacMillan House, Paddington Station,London W2 1TY
>
>
>
>
> From:
> "David Grugeon" <david@xxxxxxxxxxxxxx>
> To:
> <mso@xxxxxxxxxxxxx>
> Date:
> 27/11/2010 22:54
> Subject:
> [mso] Re: Excel behaving badly
> Sent by:
> mso-bounce@xxxxxxxxxxxxx
>
>
>
> Hi Jens
>
> Probably calculate is set to manual. (If it is you will see the word
"calculate" in
> the bottom left corner of the window. To correct this go to
> Formulas/Calculate (2007 or 2010) and set calculation to automatic.
>
> Best regards
> David Grugeon
> M-0429 029 836
> P-(07)3263 7786
>
> > -----Original Message-----
> > From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
> > Behalf Of Jens.N.Outzen@xxxxxxxxxxxxxx
> > Sent: Sunday, 28 November 2010 1:38 AM
> > To: mso@xxxxxxxxxxxxx
> > Subject: [mso] Excel behaving badly
> >
> > I have a spreadsheet which searches with a vlookup (1 sheet does the
> search
> > with the information on a different sheet).
> > For some obscure reason excel has decided that it will only do the
> search
> if I
> > save the spreadsheet rather than as it used to, when i hit the enter
> button.
> >
> > Has anyone got a good reason for this "outrageous" behaviour ?
> >
> >
> >
> > Jens N. Outzen
> >
> > Lea Interchange Depot
> > 0208 988 4700
> > 07931 904 611 (Mob)
> >
> > First Capital North Limited No 0263641 First Capital East Limited No
> > 02218277 Registered in England & Wales B Block 3rd Floor MacMillan
> > House, Paddington Station,London W2 1TY
> >
> > This message is confidential. It may not be disclosed to, or used by,
> anyone
> > other than the addressee. If you receive this message in error, please
> advise
> > us immediately.
> >
> > Internet email is not necessarily secure. First does not accept
> responsibility
> > for changes to any email which occur after the email has been sent.
> > Attachments to this email could contain software viruses which could
> > damage your system. First have checked the attachments for viruses
> before
> > sending, but you should virus-check them before opening.
> >
> > For more information on our range of services or to book your tickets
> online,
> > please visit:- http://www.firstgroup.com
> >
> >
> **********************************************************
> > ***
> > You are receiving this mail because you subscribed to
> > mso@xxxxxxxxxxxxx
> or
> > MicrosoftOffice@xxxxxxxxxxxxxxxx
> >
> > 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@xxxxxxxxxxxxxxxx
>
> 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
> **********************************************************
> ***
>
>
> This message is confidential. It may not be disclosed to, or used by,
anyone
> other than the addressee. If you receive this message in error, please
advise
> us immediately.
>
> Internet email is not necessarily secure. First does not accept
responsibility
> for changes to any email which occur after the email has been sent.
> Attachments to this email could contain software viruses which could
> damage your system. First have checked the attachments for viruses before
> sending, but you should virus-check them before opening.
>
> For more information on our range of services or to book your tickets
online,
> please visit:- http://www.firstgroup.com
>
> **********************************************************
> ***
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> 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@xxxxxxxxxxxxxxxx
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:
