I have some data that I graph.
Column A has a date [has data in 12 rows]
Column B has a data entry (number) [has data in 1st 6 rows]
Column C has a data entry (number) [has data in 1 st 6 rows]
Column D has a formula that calculates a % on column B & C [formulas in 12
The graph range I have covers the whole 12 rows but it seems to read the
formulas in col D and plots every row
Is there something I can add to my formula that stops the graph from
plotting it unless there has been an answer returned in it?
Formula I have is : =IF(B5+C5<1,"",(B5-C5)/B5)
...Defrag question #3
I have a windows 2000 server that's a file/print server and Exchange 2000
also installed and running on the same box. I was wondering what is the best
way if I want to run defrag and scandisk on the disk drive? I guess I'm
asking because exchange is running on the box and I don't know if I run
defrag and scandisk will I run into problems or cause the database problems.
Thanks for your help.
In article <4D7A888F-B293-400C-A77C-DC379DDF4BDF@microsoft.com>,
> I have a windows 2000 server that's a file/print server and Ex...Pivot Table Help #3
I have a lot of data that I am trying to analyze with a pivot table and am
not sure how to go about it.
(2) Store #
(3) 2003 Score - these are #s or text ("incomplete")
(4) 2004 Score - these are #s or text ("incomplete")
For each district, I am trying to find out 3 things:
(1) % of stores incomplete
(2) Average score for 2003 & 2004 - I've got this one working properly
(3) % change between 2003 & 2004
I can successfully analyze the data in a spreadsheet but there is too much
to go through and thought a pivot table was the way to ...Emailing from Publisher #3
A friend has OFFICE 2003. Outlook and Publisher are both 2003.
BEFORE I cleaned up temp files, she was able to "Send Page As Message" in
Now, she gets "Publisher cannot mail your publication because part of the
mail system is missing..."
All I did was delete temp files ("C:\documents and settings\[username]\local
settings\temp" and "C:\windows\temp"), and run "ccleaner".
I've put off the "reinstall your mail program" suggestion from the error
message as I don't know if she can find the install CD...
Is there any ...item look up #3
a customer is having an issue. he scans an item in the pos screen and all
details show up. but when he tries to look for it later he cant find it. hes
tried it in manager too. he would usse name, or barcode, or anything and
still nothing. do we know what the problem is?
If the item is set as inactive (in the item properties) it will not show up
in the Find screen, but will scan in at the POS. You can turn off the find
option, but I think it is easier to use one of the SOM reports to find the
item, such as the price report. The item will show up in any report that
includes it as...eft for payables #3
Can I use a current vendor and make them an eft vendor? I tried testing this
and it did not work.
I went back into my test company and the reason the current vendor was not
working was because I did not generate a pre-note first.
> Can I use a current vendor and make them an eft vendor? I tried testing this
> and it did not work.
You should be able to do this as long as you use the EFT for Payables Vendor
set up to set up the banking information for the vendor.
Setup -> Purchasing -> EFT Payables Setup -> EFT Vendor Cards
"LauraS" ...grid_container.aspx equivalent in 3.0
I was wondering if anyone knew of the 3.0 equivalent of
grid_container.aspx in MSCRM 3.0. In 1.2 it was so easy just to link to
that page, and pass in the view id to display a view from a third-party
It appears there is not the same concept in 3.0. Can anyone shed any
light on this for me?
They (aka me :-) ) rewrote the grids in CRM 3.0 and they no longer use
IFRAMEs. Instead the first page load just renders the HTML inline into a
DIV. For subsequent loads (like paging, sorting and ...Microsoft CRM 3.0 (KB922815) Installation Error
When i try to install Update Rollup 1 for MSCRM 3.0 i get following
Setup could not find Microsoft CRM 3.0 Server or you have a mismatch
between update language and Microsoft CRM language. The installation of
this update has stopped.
Is this rollup language dependent? I have a swedish installation of
Yes this rollup is language dependent. You need to install SVE(swedish - sweden) UR1 package.
This posting is provided "AS IS" with no...CRM 3.0 internal recipients don't recieve mails
We've installed CRM 3.0, including the Exchange Route Component on an
Exchange Server 2003. Inbound and outbound mails, mail tracking and so on are
working correctly, but if someone sends an email using the CRM WebInterface
or the CRM Outlook Client and uses an email-recipient of our internal domain
(e.g. as TO, CC or BCC with adress email@example.com) the mail is not
An activity that describes that email ist correctly generated by the CRM,
but the mail itself is not send to any of the listed recipients, if at least
one of them belongs to our domain.
Doe...Quote for Customer can't find data source #3
I need assistance finding the data source for the quote mail merge in
CRM 4.0. I get a error "mail_merge_64494.doc is a mail merge
document. Word cannot open the data source, ."
Here is the process I go through before I get the error:
- I open a quote
- click on menu bar button "Print Quote for Customer"
- select organization mail merge, Quote for customer, and OK
- when asked if I want to open or save, I select open
- I pick yes, when it asks if it can put data on my document
I then get message above. How do I find the datasource?
Also is there a way to configure...Internet Mail #3
I've got an ISP servicing our Internet mail, but I use
Exchange 5.5 internally, one of the users is sending mail
out to the Internet via the Exchange account but I want
it to use the ISP service, does anyone know how to
default to the ISP Internet Mail.
Thanks in advance, Craig
Craig <firstname.lastname@example.org> wrote:
> I've got an ISP servicing our Internet mail, but I use
> Exchange 5.5 internally, one of the users is sending mail
> out to the Internet via the Exchange account but I want
> it to use the ISP service, does anyone know how t...countif? #3
hi, i'm stuck with a formula.
I need to count the number of cells in the whole of column K tha
contain the numbers 6,7 and 8.
I can't seem to find a way to do this,
Any help would be greatfully recieved
Message posted from http://www.ExcelForum.com
try this. You cannot use A:A here.
"Pete JM >" <<Pete.JM.email@example.com> wrote in message
> hi, i'm stuck with a formula.
> I need to count...xy Scatter chart #3
I will try to explain this to the best of my knowledge:
I have a spreadsheet with some information that is set up like this:
Example Risk Impact Probability
Director Trls Med 3 1
Wrong Trips High 4 3
Upgrade JAX Low 1 1
These numbers are generated from a series of questions that determine wether
the risk is a high, med, or low factor. So there is really no way of knowing
what numbers determines a Low, Med, or High Risk The numbers will never go
higher than a 4 and lower th...C#, .net 3.5sp1 and Visual Studio 2008 sp1 errors list
What kind of errors will the errors list show when using C# 3.5sp1 with
Visual Studio 2008sp1?
"Andy B." <firstname.lastname@example.org> wrote in message
> What kind of errors will the errors list show when using C# 3.5sp1 with
> Visual Studio 2008sp1?
Why would you expect any?
On the face of it vs 2008 sp1 will target .Net framework 3.5 sp1 by
Andy B. wrote:
> What kind of errors will the errors list show when using C# 3.5sp1 with
> Visual Studio 2008sp1?
That all depends on what ki...Cannot view any form in crm 3.0
We have just installed CRM 3.0 on MS server 2003. I have created an account
which has a system administrator role assigned to it. The issue is that when
I open CRM web (on the server) when I select account, contact, activities,
calendar etc... I get the following error: An error has occured. For more
information, contact your system administrator.
Now if I open CRM web using an account which has restricted access mode
ticked, I don't get any errors, everything opens fine. The problem is that
with an restricted access code i can't do much.
I have tried assigning different roles ...CHtmlView question #3
Is there an easy way to get the source of the HTML document?
On MSDN online, there's a GetSource(CString& str) listed
but that's apparently not implemented in VC++ 6.0.
...CRM 3.0 SDK Web Services
I am writing a small data migration tool to migrate account and contact
data. I have approximate 1500 accounts and 6000 contacts to import to
CRM 3.0. I finished the application and ran the data migration, I will
able to migrate all of the account records without any problem at all.
when I run the contact migration, it can migrate 2800 contact records
when it get over 2800, my application throw me the following error
message: The underlying connection was closed: Unable to connect to the
remote server. I am running CRM 3.0, SQL server and my data migration
on the same server. I am wonder w...System Attendant Mailbox #3
I just installed a Exchange 5.5 Sp4 server on w2k maschine.
But I don't see my System Attendant Mailbox even if I
receive mails from it.
Could someone say me what is wrong?
Thanks a lot for any help.
Where are you looking to view the system attendant mailbox?
If you haven't tried look in mailbox resources and it should be there.
Please do not send email directly to this alias. This alias is for newsgroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"mitsi" <anonymous...Client Support Module / add-in for CRM 3.0?
We are a software company, and we just implemented CRM 3.0 for the sales
We are still using Lotus Notes for our support staff, and were curious
if there is a module that we could get for CRM to be able to handle the
Support staff as well?
This would need to be able to handle creating support tickets, allowing
for updating, and cut and paste of screen shots.
If anyone is familiar with something in this line, please let me know...
I would love to decommission Lotus Notes in the very near future.
...MS CRM 1.2 or 3.0 for Help Desk Ticketing solution
Does anyone use this for a Ticketing program? I know we have the customer
service module but have never used it. Is there any documentation on how to
set it up as a help desk solution.
Yes , U can surely do this by making a case and the case number can be
considered a s Ticket number.
You will have to dive deep into the whole process to map it to CRM
> Does anyone use this for a Ticketing program? I know we have the customer
> service module but have never used it. Is there any documentation on how to
> set it up as a help desk ...Can't Delete Rules
I have a user with some rules but the rules can't be deleted.
I got two error message and one is "The rules on this machine do not match
the rules on your exchange server" and ask "Which rules do you want to keep"
Client, Server, Cancel.
I can delete Client rules and also Server rules, but they are all back once
I restart Outlook.
The other error message is "one or more rules could not be uploaded to
Exchange server and have been deactivated."
Is there any way I can remove all of the rules?
Thanks for your comments in advance.
Start-> Ru...pivot tables #3
I am trying to change the order in how the tables
display. I don't want an accending or decending alpha
order as it is set up now. I would like to pick and
choose how I want them listed.
How do I change the order?
...automatically get an alert when someone adds an event to public Calendar?
Is there a way to automatically get an alert when someone adds an event to a
Having the person who added the event send me an invite is not an option,
because they will not do this. (I am required to check the calendar to see
if any events have been added.)
I can't see a way to quickly see what new events have been added so I have
to check the whole calendar. (Or is there a way to view events by the date
they were added, not the date of the event?)
There should be some solutions for this at =
Sue Mosher, Outlook...Junk E-Mail Filter Rules
(I posted this on an old thread but not sure anyone looks back through
If I block all e-mails from a domain using "@theirdomain.com" that
works fine, EXCEPT when the e-mail address looks like "Fred Bloggs
[email@example.com]" and then it seems to get passed over and
left in the Inbox.
Should I be blocking something else?
Use a rule with specific words in the email address and make that word
Bill R MVP
"John F Kappler" <firstname.lastname@example.org> wrote in message
news:nrtta3l3nlpdc0ngvov1jcifjva0cc9igf@4ax....Close Excel Completely Using VBA #3
Nice 1......E Oveson
I tried to search for the correct function command......
And it turned out to be
Celtic_Avenger's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1410
View this thread: http://www.excelforum.com/showthread.php?threadid=27391