Changing the Organization Name

I need to change my organization name in CRM, my license keys are registered 
under my Full Company Name and CRM was installed without the LLC. 

Note: The organization name created in the previous procedure (setting up 
CRM) must match the organization specified when your license key was obtained.


0
Utf
11/4/2005 4:33:06 PM
crm 35858 articles. 1 followers. Follow

9 Replies
532 Views

Similar Articles

[PageSpeed] 43

When you do the install, the Org Name you specifiy needs to match the Org
Name that was used for the License Keys.  So, in your case, just install it
w/o the LLC (assuming that's what your license keys are setup for).

The v1.2 install shouldn't let you by the screen where you enter this info
until the License Keys & Org Name match.

-- 

Matt Parks
MVP - Microsoft CRM


"NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
news:AA113152-D52C-4372-9C74-2C7AD546FC40@microsoft.com...
I need to change my organization name in CRM, my license keys are registered
under my Full Company Name and CRM was installed without the LLC.

Note: The organization name created in the previous procedure (setting up
CRM) must match the organization specified when your license key was
obtained.



0
Matt
11/4/2005 6:33:24 PM
Matt, 

I have already installed the CRM product with an Organization Name, I then  
received additional licenses.  These licenses are under our full name 
(Different than the Organizational Name).  I now need to change our 
Organizational Name. 

If you have a way to change the Organizational Name in the CRM I would 
appreciate the input.

"Matt Parks" wrote:

> When you do the install, the Org Name you specifiy needs to match the Org
> Name that was used for the License Keys.  So, in your case, just install it
> w/o the LLC (assuming that's what your license keys are setup for).
> 
> The v1.2 install shouldn't let you by the screen where you enter this info
> until the License Keys & Org Name match.
> 
> -- 
> 
> Matt Parks
> MVP - Microsoft CRM
> 
> 
> "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> news:AA113152-D52C-4372-9C74-2C7AD546FC40@microsoft.com...
> I need to change my organization name in CRM, my license keys are registered
> under my Full Company Name and CRM was installed without the LLC.
> 
> Note: The organization name created in the previous procedure (setting up
> CRM) must match the organization specified when your license key was
> obtained.
> 
> 
> 
> 
0
Utf
11/4/2005 8:43:03 PM
No.  What you need to do is get those new license changed to the "correct"
org name.  You can contact MBS or your VAR to get this done.

-- 

Matt Parks
MVP - Microsoft CRM


"NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
news:6CE2FF52-94C1-4F4A-B349-63D5487A098E@microsoft.com...
Matt,

I have already installed the CRM product with an Organization Name, I then
received additional licenses.  These licenses are under our full name
(Different than the Organizational Name).  I now need to change our
Organizational Name.

If you have a way to change the Organizational Name in the CRM I would
appreciate the input.

"Matt Parks" wrote:

> When you do the install, the Org Name you specifiy needs to match the Org
> Name that was used for the License Keys.  So, in your case, just install
it
> w/o the LLC (assuming that's what your license keys are setup for).
>
> The v1.2 install shouldn't let you by the screen where you enter this info
> until the License Keys & Org Name match.
>
> -- 
>
> Matt Parks
> MVP - Microsoft CRM
>
>
> "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> news:AA113152-D52C-4372-9C74-2C7AD546FC40@microsoft.com...
> I need to change my organization name in CRM, my license keys are
registered
> under my Full Company Name and CRM was installed without the LLC.
>
> Note: The organization name created in the previous procedure (setting up
> CRM) must match the organization specified when your license key was
> obtained.
>
>
>
>


0
Matt
11/4/2005 10:14:05 PM
Matt,

We have contacted MBS and they have our MBS set up with the full company 
name, that is why the licenses were sent with the Full company name.  We need 
to get the organization in the CRM changed to match.  There should be a way 
to change the name for this product.  I know in Great Plains you have the 
same issue and there is a simple way to resolve this issue.  Please advise, 
we need to get this product back up an running for all users.

"Matt Parks" wrote:

> No.  What you need to do is get those new license changed to the "correct"
> org name.  You can contact MBS or your VAR to get this done.
> 
> -- 
> 
> Matt Parks
> MVP - Microsoft CRM
> 
> 
> "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> news:6CE2FF52-94C1-4F4A-B349-63D5487A098E@microsoft.com...
> Matt,
> 
> I have already installed the CRM product with an Organization Name, I then
> received additional licenses.  These licenses are under our full name
> (Different than the Organizational Name).  I now need to change our
> Organizational Name.
> 
> If you have a way to change the Organizational Name in the CRM I would
> appreciate the input.
> 
> "Matt Parks" wrote:
> 
> > When you do the install, the Org Name you specifiy needs to match the Org
> > Name that was used for the License Keys.  So, in your case, just install
> it
> > w/o the LLC (assuming that's what your license keys are setup for).
> >
> > The v1.2 install shouldn't let you by the screen where you enter this info
> > until the License Keys & Org Name match.
> >
> > -- 
> >
> > Matt Parks
> > MVP - Microsoft CRM
> >
> >
> > "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> > news:AA113152-D52C-4372-9C74-2C7AD546FC40@microsoft.com...
> > I need to change my organization name in CRM, my license keys are
> registered
> > under my Full Company Name and CRM was installed without the LLC.
> >
> > Note: The organization name created in the previous procedure (setting up
> > CRM) must match the organization specified when your license key was
> > obtained.
> >
> >
> >
> >
> 
> 
> 
0
Utf
11/4/2005 10:41:05 PM
The only way to "change" the org name is to do a redeployment using the
Redeployment Tool.

Go back to MBS and tell them:.  The app is currently installed with Org Name
"ABC Company", our new licenses are for "ABC Company, LLC".  We need the new
licenese changed to "ABC Company".

Somewhere along the line, someone probably changed the spelling of your
company in CustomerSource, hence the change.  Good news though is that this
issue will go away in v3.

-- 

Matt Parks
MVP - Microsoft CRM


"NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
news:F43395EB-F687-4EAF-A3CC-F547B123B53A@microsoft.com...
Matt,

We have contacted MBS and they have our MBS set up with the full company
name, that is why the licenses were sent with the Full company name.  We
need
to get the organization in the CRM changed to match.  There should be a way
to change the name for this product.  I know in Great Plains you have the
same issue and there is a simple way to resolve this issue.  Please advise,
we need to get this product back up an running for all users.

"Matt Parks" wrote:

> No.  What you need to do is get those new license changed to the "correct"
> org name.  You can contact MBS or your VAR to get this done.
>
> -- 
>
> Matt Parks
> MVP - Microsoft CRM
>
>
> "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> news:6CE2FF52-94C1-4F4A-B349-63D5487A098E@microsoft.com...
> Matt,
>
> I have already installed the CRM product with an Organization Name, I then
> received additional licenses.  These licenses are under our full name
> (Different than the Organizational Name).  I now need to change our
> Organizational Name.
>
> If you have a way to change the Organizational Name in the CRM I would
> appreciate the input.
>
> "Matt Parks" wrote:
>
> > When you do the install, the Org Name you specifiy needs to match the
Org
> > Name that was used for the License Keys.  So, in your case, just install
> it
> > w/o the LLC (assuming that's what your license keys are setup for).
> >
> > The v1.2 install shouldn't let you by the screen where you enter this
info
> > until the License Keys & Org Name match.
> >
> > -- 
> >
> > Matt Parks
> > MVP - Microsoft CRM
> >
> >
> > "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> > news:AA113152-D52C-4372-9C74-2C7AD546FC40@microsoft.com...
> > I need to change my organization name in CRM, my license keys are
> registered
> > under my Full Company Name and CRM was installed without the LLC.
> >
> > Note: The organization name created in the previous procedure (setting
up
> > CRM) must match the organization specified when your license key was
> > obtained.
> >
> >
> >
> >
>
>
>


0
Matt
11/4/2005 11:40:37 PM
Hi, 

My Company was bought by another company. We where using CRM 3.0 under the 
old company licence. They want us to go through and change everything 
including CRM. I can sell them on having to redeploy as long as there is a 
way to convert/import the data from the old company… 

Any Ideas???

Regards,

am

"Matt Parks" wrote:

> The only way to "change" the org name is to do a redeployment using the
> Redeployment Tool.
> 
> Go back to MBS and tell them:.  The app is currently installed with Org Name
> "ABC Company", our new licenses are for "ABC Company, LLC".  We need the new
> licenese changed to "ABC Company".
> 
> Somewhere along the line, someone probably changed the spelling of your
> company in CustomerSource, hence the change.  Good news though is that this
> issue will go away in v3.
> 
> -- 
> 
> Matt Parks
> MVP - Microsoft CRM
> 
> 
> "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> news:F43395EB-F687-4EAF-A3CC-F547B123B53A@microsoft.com...
> Matt,
> 
> We have contacted MBS and they have our MBS set up with the full company
> name, that is why the licenses were sent with the Full company name.  We
> need
> to get the organization in the CRM changed to match.  There should be a way
> to change the name for this product.  I know in Great Plains you have the
> same issue and there is a simple way to resolve this issue.  Please advise,
> we need to get this product back up an running for all users.
> 
> "Matt Parks" wrote:
> 
> > No.  What you need to do is get those new license changed to the "correct"
> > org name.  You can contact MBS or your VAR to get this done.
> >
> > -- 
> >
> > Matt Parks
> > MVP - Microsoft CRM
> >
> >
> > "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> > news:6CE2FF52-94C1-4F4A-B349-63D5487A098E@microsoft.com...
> > Matt,
> >
> > I have already installed the CRM product with an Organization Name, I then
> > received additional licenses.  These licenses are under our full name
> > (Different than the Organizational Name).  I now need to change our
> > Organizational Name.
> >
> > If you have a way to change the Organizational Name in the CRM I would
> > appreciate the input.
> >
> > "Matt Parks" wrote:
> >
> > > When you do the install, the Org Name you specifiy needs to match the
> Org
> > > Name that was used for the License Keys.  So, in your case, just install
> > it
> > > w/o the LLC (assuming that's what your license keys are setup for).
> > >
> > > The v1.2 install shouldn't let you by the screen where you enter this
> info
> > > until the License Keys & Org Name match.
> > >
> > > -- 
> > >
> > > Matt Parks
> > > MVP - Microsoft CRM
> > >
> > >
> > > "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> > > news:AA113152-D52C-4372-9C74-2C7AD546FC40@microsoft.com...
> > > I need to change my organization name in CRM, my license keys are
> > registered
> > > under my Full Company Name and CRM was installed without the LLC.
> > >
> > > Note: The organization name created in the previous procedure (setting
> up
> > > CRM) must match the organization specified when your license key was
> > > obtained.
> > >
> > >
> > >
> > >
> >
> >
> >
> 
> 
> 
0
Utf
4/20/2006 8:20:02 PM
Use the redeployment tool.

-- 

Matt Parks
MVP - Microsoft CRM


"am" <am@discussions.microsoft.com> wrote in message 
news:7ACF64C5-4674-456C-9C68-362194A13F67@microsoft.com...
Hi,

My Company was bought by another company. We where using CRM 3.0 under the
old company licence. They want us to go through and change everything
including CRM. I can sell them on having to redeploy as long as there is a
way to convert/import the data from the old company.

Any Ideas???

Regards,

am

"Matt Parks" wrote:

> The only way to "change" the org name is to do a redeployment using the
> Redeployment Tool.
>
> Go back to MBS and tell them:.  The app is currently installed with Org 
> Name
> "ABC Company", our new licenses are for "ABC Company, LLC".  We need the 
> new
> licenese changed to "ABC Company".
>
> Somewhere along the line, someone probably changed the spelling of your
> company in CustomerSource, hence the change.  Good news though is that 
> this
> issue will go away in v3.
>
> -- 
>
> Matt Parks
> MVP - Microsoft CRM
>
>
> "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> news:F43395EB-F687-4EAF-A3CC-F547B123B53A@microsoft.com...
> Matt,
>
> We have contacted MBS and they have our MBS set up with the full company
> name, that is why the licenses were sent with the Full company name.  We
> need
> to get the organization in the CRM changed to match.  There should be a 
> way
> to change the name for this product.  I know in Great Plains you have the
> same issue and there is a simple way to resolve this issue.  Please 
> advise,
> we need to get this product back up an running for all users.
>
> "Matt Parks" wrote:
>
> > No.  What you need to do is get those new license changed to the 
> > "correct"
> > org name.  You can contact MBS or your VAR to get this done.
> >
> > -- 
> >
> > Matt Parks
> > MVP - Microsoft CRM
> >
> >
> > "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> > news:6CE2FF52-94C1-4F4A-B349-63D5487A098E@microsoft.com...
> > Matt,
> >
> > I have already installed the CRM product with an Organization Name, I 
> > then
> > received additional licenses.  These licenses are under our full name
> > (Different than the Organizational Name).  I now need to change our
> > Organizational Name.
> >
> > If you have a way to change the Organizational Name in the CRM I would
> > appreciate the input.
> >
> > "Matt Parks" wrote:
> >
> > > When you do the install, the Org Name you specifiy needs to match the
> Org
> > > Name that was used for the License Keys.  So, in your case, just 
> > > install
> > it
> > > w/o the LLC (assuming that's what your license keys are setup for).
> > >
> > > The v1.2 install shouldn't let you by the screen where you enter this
> info
> > > until the License Keys & Org Name match.
> > >
> > > -- 
> > >
> > > Matt Parks
> > > MVP - Microsoft CRM
> > >
> > >
> > > "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> > > news:AA113152-D52C-4372-9C74-2C7AD546FC40@microsoft.com...
> > > I need to change my organization name in CRM, my license keys are
> > registered
> > > under my Full Company Name and CRM was installed without the LLC.
> > >
> > > Note: The organization name created in the previous procedure (setting
> up
> > > CRM) must match the organization specified when your license key was
> > > obtained.
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
> 


0
Matt
4/21/2006 2:34:51 PM
Thanks Matt, I found (and downloaded) the utilities... I'll give them a try...

am


"Matt Parks" wrote:

> Use the redeployment tool.
> 
> -- 
> 
> Matt Parks
> MVP - Microsoft CRM
> 
> 
> "am" <am@discussions.microsoft.com> wrote in message 
> news:7ACF64C5-4674-456C-9C68-362194A13F67@microsoft.com...
> Hi,
> 
> My Company was bought by another company. We where using CRM 3.0 under the
> old company licence. They want us to go through and change everything
> including CRM. I can sell them on having to redeploy as long as there is a
> way to convert/import the data from the old company.
> 
> Any Ideas???
> 
> Regards,
> 
> am
> 
> "Matt Parks" wrote:
> 
> > The only way to "change" the org name is to do a redeployment using the
> > Redeployment Tool.
> >
> > Go back to MBS and tell them:.  The app is currently installed with Org 
> > Name
> > "ABC Company", our new licenses are for "ABC Company, LLC".  We need the 
> > new
> > licenese changed to "ABC Company".
> >
> > Somewhere along the line, someone probably changed the spelling of your
> > company in CustomerSource, hence the change.  Good news though is that 
> > this
> > issue will go away in v3.
> >
> > -- 
> >
> > Matt Parks
> > MVP - Microsoft CRM
> >
> >
> > "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> > news:F43395EB-F687-4EAF-A3CC-F547B123B53A@microsoft.com...
> > Matt,
> >
> > We have contacted MBS and they have our MBS set up with the full company
> > name, that is why the licenses were sent with the Full company name.  We
> > need
> > to get the organization in the CRM changed to match.  There should be a 
> > way
> > to change the name for this product.  I know in Great Plains you have the
> > same issue and there is a simple way to resolve this issue.  Please 
> > advise,
> > we need to get this product back up an running for all users.
> >
> > "Matt Parks" wrote:
> >
> > > No.  What you need to do is get those new license changed to the 
> > > "correct"
> > > org name.  You can contact MBS or your VAR to get this done.
> > >
> > > -- 
> > >
> > > Matt Parks
> > > MVP - Microsoft CRM
> > >
> > >
> > > "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> > > news:6CE2FF52-94C1-4F4A-B349-63D5487A098E@microsoft.com...
> > > Matt,
> > >
> > > I have already installed the CRM product with an Organization Name, I 
> > > then
> > > received additional licenses.  These licenses are under our full name
> > > (Different than the Organizational Name).  I now need to change our
> > > Organizational Name.
> > >
> > > If you have a way to change the Organizational Name in the CRM I would
> > > appreciate the input.
> > >
> > > "Matt Parks" wrote:
> > >
> > > > When you do the install, the Org Name you specifiy needs to match the
> > Org
> > > > Name that was used for the License Keys.  So, in your case, just 
> > > > install
> > > it
> > > > w/o the LLC (assuming that's what your license keys are setup for).
> > > >
> > > > The v1.2 install shouldn't let you by the screen where you enter this
> > info
> > > > until the License Keys & Org Name match.
> > > >
> > > > -- 
> > > >
> > > > Matt Parks
> > > > MVP - Microsoft CRM
> > > >
> > > >
> > > > "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> > > > news:AA113152-D52C-4372-9C74-2C7AD546FC40@microsoft.com...
> > > > I need to change my organization name in CRM, my license keys are
> > > registered
> > > > under my Full Company Name and CRM was installed without the LLC.
> > > >
> > > > Note: The organization name created in the previous procedure (setting
> > up
> > > > CRM) must match the organization specified when your license key was
> > > > obtained.
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> > 
> 
> 
> 
0
Utf
4/21/2006 3:34:02 PM
Hi Matt,

I see in the Guide for the 3.0 RD tool its says that it does not 'recommend' 
renaming the databases as part of the redeployment. (Step 4 Pg 6).

Will this actually work? (strange, cause you could do it in 1.2)

Thanx
-- 
Glen Howie
Microsoft CRM Product Specialist
WolfBridge Solutions
www.wolfbridgesolutions.com



"Matt Parks" wrote:

> Use the redeployment tool.
> 
> -- 
> 
> Matt Parks
> MVP - Microsoft CRM
> 
> 
> "am" <am@discussions.microsoft.com> wrote in message 
> news:7ACF64C5-4674-456C-9C68-362194A13F67@microsoft.com...
> Hi,
> 
> My Company was bought by another company. We where using CRM 3.0 under the
> old company licence. They want us to go through and change everything
> including CRM. I can sell them on having to redeploy as long as there is a
> way to convert/import the data from the old company.
> 
> Any Ideas???
> 
> Regards,
> 
> am
> 
> "Matt Parks" wrote:
> 
> > The only way to "change" the org name is to do a redeployment using the
> > Redeployment Tool.
> >
> > Go back to MBS and tell them:.  The app is currently installed with Org 
> > Name
> > "ABC Company", our new licenses are for "ABC Company, LLC".  We need the 
> > new
> > licenese changed to "ABC Company".
> >
> > Somewhere along the line, someone probably changed the spelling of your
> > company in CustomerSource, hence the change.  Good news though is that 
> > this
> > issue will go away in v3.
> >
> > -- 
> >
> > Matt Parks
> > MVP - Microsoft CRM
> >
> >
> > "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> > news:F43395EB-F687-4EAF-A3CC-F547B123B53A@microsoft.com...
> > Matt,
> >
> > We have contacted MBS and they have our MBS set up with the full company
> > name, that is why the licenses were sent with the Full company name.  We
> > need
> > to get the organization in the CRM changed to match.  There should be a 
> > way
> > to change the name for this product.  I know in Great Plains you have the
> > same issue and there is a simple way to resolve this issue.  Please 
> > advise,
> > we need to get this product back up an running for all users.
> >
> > "Matt Parks" wrote:
> >
> > > No.  What you need to do is get those new license changed to the 
> > > "correct"
> > > org name.  You can contact MBS or your VAR to get this done.
> > >
> > > -- 
> > >
> > > Matt Parks
> > > MVP - Microsoft CRM
> > >
> > >
> > > "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> > > news:6CE2FF52-94C1-4F4A-B349-63D5487A098E@microsoft.com...
> > > Matt,
> > >
> > > I have already installed the CRM product with an Organization Name, I 
> > > then
> > > received additional licenses.  These licenses are under our full name
> > > (Different than the Organizational Name).  I now need to change our
> > > Organizational Name.
> > >
> > > If you have a way to change the Organizational Name in the CRM I would
> > > appreciate the input.
> > >
> > > "Matt Parks" wrote:
> > >
> > > > When you do the install, the Org Name you specifiy needs to match the
> > Org
> > > > Name that was used for the License Keys.  So, in your case, just 
> > > > install
> > > it
> > > > w/o the LLC (assuming that's what your license keys are setup for).
> > > >
> > > > The v1.2 install shouldn't let you by the screen where you enter this
> > info
> > > > until the License Keys & Org Name match.
> > > >
> > > > -- 
> > > >
> > > > Matt Parks
> > > > MVP - Microsoft CRM
> > > >
> > > >
> > > > "NSMeritel" <NSMeritel@discussions.microsoft.com> wrote in message
> > > > news:AA113152-D52C-4372-9C74-2C7AD546FC40@microsoft.com...
> > > > I need to change my organization name in CRM, my license keys are
> > > registered
> > > > under my Full Company Name and CRM was installed without the LLC.
> > > >
> > > > Note: The organization name created in the previous procedure (setting
> > up
> > > > CRM) must match the organization specified when your license key was
> > > > obtained.
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> > 
> 
> 
> 
0
Utf
4/26/2006 4:09:02 PM
Reply:

Similar Artilces:

name of web service address
"glenn nehh" <glenn nehh@discussions.microsoft.com> wrote in message news:4ECA33FA-757C-4372-8032-97B2F976E887@microsoft.com... > I shall name it... Bob. In all seriousness, huh? -- f.h. ...

How do I change my text direction to vertical on EXcell?
How do I change my text direction to vertical on EXcell? <Format> <Cells> <Alignment> tab, Under "Orientation", drag the Text indicator to either +90� or -90�. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "bibi" <bibi@discussions.microsoft.com> wrote in message news:9F710989-54DA-4666-9FEC-186ECAE52734@microsoft.com... > How do I change my text direction to vertical on EXcell? You can also type "Alt-Enter&qu...

Can the Date Format be Changed
Is there a way to change the date format in MS Money 2004? Regards, Kevin Quite easily, just change the date format in Control Panel and Money should use it/. -- Glyn Simpson, Microsoft MVP - Money Check http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny for UK tips and fixes for MS Money. To send Microsoft your wishes or suggestions, use http://register.microsoft.com/mswish/suggestion.asp or email mnyukwsh@microsoft.com especially if it's a UK specific wish. I do not respond to any unsolicited email regarding Money "Kevin" <Lundquisk001@hawaii.rr.com> wrot...

Case statement vs Change/lookup table
Hello All Gurus, This is a problem that I have encountered and was wondering what would be a better approach to the solution I have a view that is pulling data from a table which is fed from an external application. Some of the data due to external situations is wrong/spelled wrong, in the past when this happened I updated another view with a complex set of case statements. This is fast and stable, however, it is for only three instances as they are the only mistakes and they happen always, aka the data is always spelled wrong for these three instances. Now there is a situation wher...

Xcel or Access sort columns of names so that I remove the intersect between 2 columns from one of the columns?
Hi, I have currently in Xcel and long list of X English phrases in one column with associated numerical data about each name in adjoining columns. I have on another workbook (which could of course be pasted into this workbook)another similarly set out column of Y English phrases again with ajoining columns having numberical data row that the phrase. I would like to be able to sort the second column of phrases removing all the phrases that occured in the first column. Ideally it would be great to have the numerical data for the remaining English phrases still on the same rows (not necessary ...

How do I change currency exchange rates?
I have US stock held in a Cdn investment portfolio. (I also have US stock in a US portfolio). Money 2006 uses the same exchage rate all the time when I look at the portfolio manager. How do I adjust the exchange rate for each day, at month end. It would be great to be able to balance my statements. -- Thanks, Jen Money uses the most recently downloaded rate for all conversions it shows at one time. You can enter the rate--but it's still only one rate, not a daily series of them. To change exchange rates, go to Tools | Settings | Programs settings | Update currencies. "JennyL...

DLookup #Name? Error
I'm trying to have a text field default to a mainframe date format which is text YYYYMM. If the current month is 3/1/2008 than the default MF date would be 200802, if the current month is 4/1/2008, than the default date would be 200803, and so on. My table is just two fields: one with the Mainframe date [CASDate]and one with the current month date [Current]. The formula below is giving me a #Name? error and I can't figure out why as the fields are named correctly: CASDate is the mainframe date; dbo_uDateTable is the table that has the two fields, Current is the current date (3/1...

Auto Price change
I have a prospect who wants to have his POS system to automatically change his item prices according daily fluctuations in the Native currency he is receiving payment in from his Customers compared to the Foreign currencies he purchases them in (simply by changing the Exchange rates in the system, not by any Receiving voucher or manual Cost adjustment). Add to this, he would like it to reflect the different currency values per item according to the default currency assigned to the vendor the items came from. -- Mike Haugen Retail Technology Experts (RTE) This is a development that we w...

Changing Of Column Values ?
Hello, Using Excel 2007 and Windows7 This sure seems "funny," and was hoping someone might explain it for me: In B1 I have the value 154.22 In B2 I have the value 33.74 In E1 I have 154000000 In E2 I have 33740000 I copy from Column E, and do a Paste Special in Column B Column B looks correct, as it has in: B1 the value 154220000 B2 the value 33740000 But- E1 has changed to 1.5422E+14 E2 has changed to 3.374E+13 In the Paste Special dialog box that came up I selected for Paste: Values, and Operation: None As the values in B look correct, I'...

Change default location of pop up message box
I want to attach a message to the cell that pops up when the cursor is positioned over the cell. I have created the message and when I hold the cursor over the cell the message displays correctly. However, the problem is that because I have "frozen" rolls and columns (to keep the columns descriptions in view when scrolling through the worksheet) that the "frozen" lines show up in the message box. QUESTION: Is there anyway to move the location of the message box when you hold the cursor over it. I already know how to move the location of the message box when you...

Changing the page setup for printing
Hi there Currently, when my report prints, it is in landscape. How can I change it so that it prints portrait and is reduced 75%? Is it possible to set this up in a macro? Thank you Open your report in design mode and then setup your layout and properties and you want them to be. In your case goto Page Setup and change the page orientation to portrait. Then set your page content to fit within the page boudaries. Save your changes and then this is the way they will be from now on. -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access ...

Last Name, First Name
In version 1.2 we incorreclty set up the database as Last Name, First Name. I see in Version 3 going forward we change this for new records. Is there a way I can go into the database and dorrect this to First Name LAst Name, and then change the format going forward. Thanks Kim In both versions, there is a setting under the system settings to control this for ongoing updates. Then, you can issue a direct SQL update on the underlying ContactBase & LeadBase tables to update the fullname field to be the correct value. Be carefule updating the tables though. This is not a supported ...

Outlook Mail Item Duplicate "Display Name" Problem
Dear all, I'm currently writing a Persona Menu smart tag in Outlook 2003. I use dynamic caption and intend to modify the "Additional Actions" sub-menu depending on the contact(in the MAPIFolder) that the tag is referring to. Problem occurs in the mapping of the tag and OL contact. All information I can find from the smart tag action DLL(with ISmartTagAction2 interface) is just the tagged text string from get_VerbCaptionFromID2() but not the entity object that calls the persona menu. So my way to complete the chain is to : 1) search the sender and recipients' "display...

Data Files
How do I change the save location of my money file from the default location to a location of my choice (an external usb drive) In money: Tools button Options... Back-up tab Save in: box Make changes as desired. Or use Browse button >-----Original Message----- >How do I change the save location of my money file from >the default location to a location of my choice (an >external usb drive) >. > Thanks. I will give this a try. >-----Original Message----- >In money: >Tools button >Options... >Back-up tab >Save in: box >Make changes as desired. &...

Change how Outlook shows attachments?
Can anyone explain how Outlook decides to show attachments? Ordinary Word or Excel files. Sometimes the attachment is inline with the message, actually showing the file icon (ex: word.doc) in the body of the email. Other times it will show in the message header, with a paper clip icon. Now, a user complains, nothing shows at all! The attachmant is there, and by going to File|Save Attachment I can get to it. How to control this? Thanks for any insight or leads! Nat Check the format of the emails. Rich text will show attachments in the body, HTML or plain text should show it either at t...

Changing bar graph legend?
I am a teacher trying to teach students how to graph rivers in differen continents and their length. I can get the rivers and length graph, bu I want the legend to show only the continents (e.g. I have 2 rivers i Europe and want them both the same colour and the legend to say Europ for that colour). The only way I seem to be able to include th continents in this way is for the legend to say both the continent an the river name, which is a bit redundant since the river name i already on the x-axis. Is there any way of putting information only i the legend? I hope this description is clear enoug...

Change default sent to program from Windows live mail to OE
Hi When a right click on any file while viewing in Explorer and choose Sent to > Mail recipient, the default email program that opens is Live Mail, but i want Outlook Express. This is even after after changing my default mail handler to Outlook Express. Is there a way to correct this ? Thanks ! Daniel I forgot to mention I use XP ans Outlook express 6 "Daniel as twiggy144" <nospam@nospam.com> wrote in message news:u4YRNj$qKHA.4236@TK2MSFTNGP02.phx.gbl... > Hi > > When a right click on any file while viewing in Explorer and choose Sent ...

change cost rates table
How can i change the cost rate table of resource in project professional 2007 Open the resource in the Resource Pool with MS Project. Doubleclick on the resource. Select the Costs tab. - Andrew Lavinsky Blog: http://blogs.catapultsystems.com/epm > How can i change the cost rate table of resource in project > professional 2007 > ...

Adding Company Name to Addresses
When you use your Outlook 2002 Contacts folder to insert a single address into a Word document, only the full name and the address lines are inserted. How can you automatically include the Company name in the inserted address? To learn about ways to control how an Address is inserted into Word from Outlook, take a look here: http://www.slipstick.com/contacts/insword.htm http://support.microsoft.com/default.aspx?scid=KB;en-us;q134901 -- Russ Valentine [MVP-Outlook] "Linda B" <anonymous@discussions.microsoft.com> wrote in message news:18f801c48c5f$26cbf8e0$a301280a@...

Order of Address Book (name recognition) recipients
I have a question as this is driving me crazy. When I send an email to my husband and type in his name my outlook express automatically fills in the rest of the name until I continue to type and it becomes obvious. The problem is that I have 3 people in my address book with the same first name that I never email and I want my husbands name to come up first when I type in the name "Scott". Because the others have names closer to the letter A (alphabetized) he is not the first one that pops up and I have to keep typing. How do I change the order of name recognition? Thanks! Thi...

Changing Colour of Bar depending on Value
Hi there, I am trying to put together an attendence register for some students, th calculations are sorted, but what I want to do is create a bar graph showing total percentage attendance but having the bar change dependin on the value. e.g. if attendance is 100% a Green Bar, if say 80% Amber and if 60% Red. Is this possible? Cheers Here's a conditional charting approach that uses separate series for each format: http://peltiertech.com/Excel/Charts/ConditionalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions...

Macro execution changes filename reference for all macros
Long ago (10 or more years) I created a mailing list application, using Excel 97 originally, with updates along the way using Excel 2000 and 2003. The application has been running with Excel 2007 for 18 months without a problem. Everything has worked smoothly until about two weeks ago. The user clicks on any of a number of control button on a worksheet to call a series of routines. In the troublesome routine a list is sorted and filtered. The filtered list is copied to a new sheet. The sheet is renamed. The sheet is then moved to a new book. The problem occurs when the...

Rapid change between companies
Changing companies is very slow in 9.0. Request either significantly improved switching time or ability to not consume user license when running multiple instances from same Terminal Server session or same workstation. The latter model allows user to Alt-Tab between companies which switches companies very quickly. It is the same user working in only company at a time but being logged into multiple companies. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree&quo...

Preventing changes on inventory cards
I need some help in security - I would like to prevent others from changing the information in the inventory cards but still allow them to see all the information. Where do I go on advanced security to do this? Thanks You need to deny access to the cards and grant access to the inquiries. That's the easiest way to let people view data and not let them touch it. "Gloria" wrote: > I need some help in security - I would like to prevent others from changing > the information in the inventory cards but still allow them to see all the > information. > > Whe...

External reference changing the link
Hi, I have a worksheet full of external references to other worksheets on network drives. I have recently updated to excel 2003 and now when I open the workbook, the links point to somewhere on my harddrive (c-drive). How do I get the sheet to point to the network?.. I still have access to the files on the network. The consequence is that I cant work in the files, because if I save them, I completely mess up the links for everybody else. I hope somebody can help me here. Thx. Lars -- 50pingviner ------------------------------------------------------------------------ 50pingviner...