I have a question..I have a client and they want us to test things on a
machine beofre he moves it out into the lanes...
is there a way that I can install on a machine thats not going to be a lane
for testing purposes then be able to transfer it to a lane with no problems?
I think you just need to get the demo version first for testing
"Angelique" <Angelique@discussions.microsoft.com> wrote in message
>I have a question..I have a client and they want us to test things on a
> machine beofre he moves it out ...Total a column from sheet 2 based on value in sheet 1
Col B Col C Col F
Mary Team 1 $331.00
George Team 1 $222.00
Sam Team 2 $186.00
Tom Team 2 $100.00
Above is an example of my data on Sheet 2. On Sheet 1, I want to total all
the total funds raised per Team shown on Sheet 2. I am trying to create a
summary of what each team raised.
I tried using the formula: =SUM(('sheet 2'!F2:F482=Sheet1!B2)) and I get
just a dash in my total col.
Can anyone provide some help?
Look in HELP for the SUMIF() function
Microsoft MVP - Excel
"Nee...Also Can't Install Latest Update
Operating System: Mac OS X 10.5 (Leopard)
I'm using a registered version of Office 2008, version shows 12.0.0. Have been trying to install the latest patch 12.1.0 with no success. It sits for ages on the 'examining additional volumes' stage (there are no additional volumes) and then eventually puts the red exclamation mark on my disk with the note, "..a version of the software required is not on this computer.."
I have tried the Autoupdater and the standalone download. Have tried with nothing else running (shift key held whilst logging-in)...Failed to install: Business Data Lookup Snap-in for CRM 3.0
I went through the Installation wizard without errors or warnings.
The Business Data Lookup Snap-in for Microsoft CRM toolbar does not appear
in Word or Excel. I have tried to do as was instructed in readme-file, but it
I should click View -> Toolbars -> Business Data Lookup Snap-in for
Microsoft CRM, but the toolbar is the same than before (no Business Data
...vlookup 2 columns
I have in sheet1 data like this,just eg :-
Ord Part Date
890 123 01/02/2004
900 123 01/17/2004
900 492 01/17/2004
914 123 01/20/2004
But when i do vlookup in sheet2 the date column looks like this.
Ord Part Date
890 123 01/02/2004
900 123 01/02/2004
900 492 01/17/2004
914 123 01/02/2004
While vlookup,the date column takes the first DATE occurance for the
I want to compare both the part no as well as order no while doing
I need something l...How to tell what Updates have been Installed?
I just tried the Microsoft AutoUpdate and it says there are no updates
for your software at this time. I then clicked on the "View Installed
Update" button and shows no history. Just blank page.
My Entourage version is 12.0.1 and I think this is the current version.
Should the 12.0.0 to 12.0.1 update be displayed on the installed updates
How can this update be added to the blank installed updates page?
There were some issues with 12.0.1, obviously--it doesn't show on my
I don't know for sure, but I would expect that 12.1 will be a combo
updater...Is CRM a good tool for marketing list management?
In conversation, the question came up on whether or not CRM is a good tool
for marketing list management. One of the main concerns is that the by
loading hundreds of accounts and thousands of contacts into the database,
performance will degrade. (Currently we have about 360 companies and about
On May 23, 3:39 pm, Medardo Lacayo
> In conversation, the question came up on whether or not CRM is a good tool
> for marketing list management. One of the main concerns is that the by
> loading hundreds of ac...Page Numbering (Starting Number Other Than 1)
I am at a loss as to how to start page numbering with
number other than 1. I am using Office Pro 2003 with
When I go to Tools/Options, I do not find the familiar
menu "Start Numbering With . . " menu.
What to do??
Go to Page 1, Insert|Section
JoAnn Paules - MVP Microsoft Publisher
"Bill" <firstname.lastname@example.org> wrote in message
> I am at a loss as to how to start page numbering with
> number other than 1. I am using Office Pro 2003 with
> Publisher 2002.
> When I ...Value Pak Installer
Does anyone know how I would access Value Pak installer for Mac Office X?
Can it be downloaded from the Microsoft web site, and if so, where?
On 3/6/04 6:59 am, in article email@example.com,
"Brian" <firstname.lastname@example.org> wrote:
> Does anyone know how I would access Value Pak installer for Mac Office X?
> Can it be downloaded from the Microsoft web site, and if so, where?
For Office vX, the value pack is on the installation CD.
For Office 2004, there is no separate value pack.
Barry Wainwrigh...1 email fill my queue!!!!
I'm testing a deployment of the CRM 1.2.
I test the exchange filter to get email sent to email@example.com.
This works fine... but...
every 30minutes the same email is added to the queue again!!!!
I have done 2 tests, and these 2 emails are copied every 30minutes...
I have omit to check the "associated external account" option in the
Exchange advanced options.
"J�j�" <willgart_A_@hotmail_A_.com> wrote in message
> I'm testing a...Unable to access different views within CRM
My client is using Windows XP Pro with Internet Explorer 6. She can log onto
the web-client and access my opportunties, my contacts, my leads etc. When
she attempts to change views i.e. all opportunities she receives an error
message 'an error has occured, please contact your system admin'.
...HELP. CRM Authentication
The installation went well. But I cant open the CRMwebiste. Anytime, I get
this error message:
"Microsoft CRM could not log you on to the system. Make sure your user
record is enabled and that you have been assigned at least one security role.
For more information, contact your system administrator. "
Also, in CRM Deployment manager, I cant work on user manage. The error
"The server http://crmserver:8080/mscrmservices is nt responding. This might
happen if it is currently unavailable, it is not a microsoft CRM server, or
you do not have sufficient priviled...Installation #4
I am not sure that I am in the right place but I am
trying to install Disc2 of Office 2000 Pro on Windows Xp.
I keep getting a Not Responding prompt after I key in the
Product Key Code. It identifies a file or something that
is ---- SzAppName: msiexec.exe
I really could use some help getting this resolved. I was
able to install Disc1 with Word and such on it. I would
like to install Disc2 that has Publisher and Small
Please advise ASAP.
Hi Paul (firstname.lastname@example.org),
in the Microsoft� newsgroups
|| I am not sure that I am in the right place bu...Do I need to install Office 2003 updates for Window 7?
I have a new computer with Window 7 operating system. I used my original disk
and product code to install Office 2003 and it seemed to go well. Now I am
wonering if I need to go back and install Office 2003 updates. I am
primarily worried about Office 2003 security but thinking maybe Windows 7
takes care of that. If Windows 7 does not, which ones need to be used to
update and how do I get access to them?
"Gracious" <Gracious@discussions.microsoft.com> wrote in message
> I have a new computer with ...CRM Cannot Go Online -- Button Doesn't Work
CRM Go-Onlie Button Doesn't Work .
I have a client whose go-online button doesnt' work. We are running CRM 3.0 on Rollup 1 and service pack 2 with Office 2003. We do have an exchange server 2007.
When you say the button doesn't work, do you mean that clicking on the button
produces no result, or that errors occur during the Go Online process? If
clicking the button produces no result, try opening Advanced Find or a new
phone call record from the toolbar. If those also don't work, then check to
make sure the CRM add-in is not disabled: in Outlo...Bullet Points #2
Can you add bullet points in Excel....Bizarre question but I have to ask...
Thanks in advance for any advice...
Hold down Alt and press the numpad 0149, release the Alt key
For everyone's benefit keep the discussion in the newsgroup.
"Gregory Jones" <email@example.com> wrote in message
> Dumb question...
> Can you add bullet points in Excel....Bizarre question but I have to
> Thanks in advance for any advice....
Thanks ve...Installer for my access application
I searching for installer for my program.
It must support creating link like "path to msaccess.exe" "path to
myprog.mde" /wrkgrp "path to users.mde"
Is anybody know best solution for this???
Thank you in advance.
With best regards, Alek Luchnikov. E-mail:
Look at Inno setup. It's free.
"Alek Luchnikov" <alekluch---FORSPAMERSfirstname.lastname@example.org> wrote in message
> Hello, All!
> I searching f...Fresh install, crystal issue.
During an install on an Enterprise server 03 SP1, I have run into DEP or Data
Encription Protection. This stops each of the crystal services upon install
and therefor after the install we recieved the infamous crystal license
error. We checked and the APS service is not started and will not start no
matter what we try. Also there is three tables missing from the Crystal
database: APS_IdNumbers2, APS_InfoObjects2 and APS_VersionInfo.
I am guessing that the missing tables is the reason the APS wont start, If I
copied these three tables from another database would this work for getting
...excel report manager #2
I did all required in installation and when the report manager comes up
I get no options either under "view or scenario", All I see is "none".
No choice for any of the 6 out of 20 columns I want to print.
Is my Report Manager corrupted? I just d/l it today from the MS site
...Installing XP over Linux
I am trying to install Windows XP on a Dell laptop that currently has Linux
Ubuntu installed. After booting up with the Windows CD in the drive, it
loads various Windows files, but eventually stops on a blue screen message
advising me to run CHKDSK, but won't respond after that. I suspect that
Windows is seeing the Linux partitions as disk corruption, but how can I get
"Kev" <email@example.com> wrote in message
>I am trying to install Windows XP on a Dell laptop that currently has Linux
>Ubunt...Problem uninstalling CRM for Outlook
I am having a problem when uninstalling the CRM for Outlook Toolbar. When I
log onto the machine as the user who installed the CRM toolbar, I receive an
error "This action is valid for products that are currently installed". We
did have to delete the NT profile of the user which installed CRM toolbar, so
I assume this is related to this problem.
Thanks for your help!
...CRM SBS install error
I installed CRM on SBS 2003 and had 1 problem with the Reporting Server being
incorrect. But the CRM Setup Wizard tool would not run (kept getting an
So, I tried a repair of the CRM setup - no good. Then did an uninstall, and
re-install. The install will not work - I keep getting the following error:
Action Microsoft.CRM.Setup.Server.RegisterFaxService failed. The
configuration registry key is invalid.
I have not seen any posts that mention an error like this. Any idea what to
Were you installing on SBS 2003 premium?
...Cannot see installed fonts in programs after installing with Font
OS 10.4 with current updates. Installed a TTF using the Font Book and it
shows there correctly. But when going into Word for example, type in text,
highlight it, click on the font format and the new font that was installed
will not show in the list. I have already tried deleting the font cache,
then rebooting and reinstalling the font thru the Font Book and just manually
copying to the /Library/Fonts folder.
Althought it sounds like you may already be aware of what it refers to,
below is an excerpt from;
http://www.macreviewzone.com/archive/hardcider/guestreviews/swope/osx_fonts.sht...Compare 2 Sheets and Extract Unique Info to a 3rd Sheet
I have two sheets of stock data from a stock screener, both same
parameters, just different time frames (i.e., one sheet is newer
whenever I import new a new screen from the Internet), which will pull
different stocks as time passes. I'm trying to compare the two sheets
and extract the stock data (a whole row's worth of data, not just a
cell) that is unique to the "Last Import" sheet. This would allow any
new stocks identified on the screener to be transferred to a new sheet
(called "Filtered List"). That way I don't have to research the same
stocks over and ove...Email Tracking
With Version 1.2 we could send out an email using MSCRM, and the
response from the customer (assuming the token was left alone in the
subject line) would also be aggregated to the history of activities -
without user intervention. (So I would see both emails tracked against
the customer's activity history without having to do anything)
With version 3.0, the responses via email only come through to outlook
and do not have the tracking done automcatically in MSCRM, eventhough
the token is left inside the subject line. Users now need to manually
click on "track in CRM"...