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 ...Removing hyperlinks in Excel by multiplying by 1 is very obtuse
I just followed the Excel help directions for "Remove a hyperlink" ->
"Deactivate several hyperlinks at once". And while the directions work
(multiplying each field by 1), they strike me an obscure work around to a
rather obvious missing feature. It should be easy to remove hyperlinks from
text in Excel, especially because Excel is very agressive about auto-creating
hyperlinks when any text that resembles a web address is entered. Hopefully
this missing feature will be addressed in the next verison of Excel.
post your suggestion to:
Reg...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...Best book for learning MFC/VC 7.1 for developing rich GUI apps ?
I am a C/C++ developer of quite a few yesrs, although I am relatively
new to Windows (Unix background). I am about to begin work on a project
that would require me to develop several GUI rich frontend applications.
I would like to hear from developers ou there if there is a book they
would recommend, to help me hit the ground running - i.e. a book that is
NOT an introductory text on programming/C++ but rather one that dives
straight in and shows how to create front ends (possibly widgets etc) -
using the VC IDE, one that covers all I need to know about MFC to start
working on a re...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...Strange Error (CRM 1.2)
I have a Virtual PC configuration set up for CRM demos. I have one image
that has CRM 1.2 under Windows 2003 server. It is all configured and setup
and running fine. I have another image with Windows XP configured. The
two images see each other and communicate.
From my Windows XP image I can access CRM both via browser and Outlook
Client. However, occassionally I can't access the system via Outlook and
when I try it via the browser I get a screen coming up with "Sonic Wall" on
it asking for a login and password. If I enter in "Administrator" for the
login...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 firstname.lastname@example.org) 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...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 <email@example.com> 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...trying to split a stock 1:4
When I were trying to split a stock using Money2000,
Money2000 ended up telling me: "The stock split can not
be completed due to a lack of disk space." But I still
have 18G left on my hard disk.
In microsoft.public.money, Wei wrote:
>When I were trying to split a stock using Money2000,
>Money2000 ended up telling me: "The stock split can not
>be completed due to a lack of disk space." But I still
>have 18G left on my hard disk.
I would try booting into Safe Mode and see if you can do the split.
I don't expect it to solve the problem, but it is ea...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.firstname.lastname@example.org> wrote in message
> hi, i'm stuck with a formula.
> I need to count...2003 recipient policy for exchange 5.5
Can a recipient policy created on 2003 to purge mail in the deleted items
folder also be used for exchange 5.5 in the same site?
On Sun, 26 Feb 2006 22:16:19 -0500, "John Stimpson"
>Can a recipient policy created on 2003 to purge mail in the deleted items
>folder also be used for exchange 5.5 in the same site?
I would say not.
There is the Mailbox Manager feature in 5.5. Are you able to use that
or did you just want something with a single interface?
...Media players opens and keeps trying to refresh about 5 times a mi
I have done numerous spyware chaecks all showing nothing detected
I have eliminated any options in the media player that would have it trying
to check for updates or web items.
Completely at a loss and extremely unhappy the microsoft site does not have
Acer Exyenza Laptop with Win XP , Office 07 and player 11
any help guys?
in the time in took to type this meassage the player popped up three times
Try disabling (unchecking) all active WMP plug-ins in WMP's Options.
If you download and run Process Explorer -
http://technet.microsoft.com/en-us/sysinternals/bb8...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." <email@example.com> 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...Net Worth Report on Money 2002
I have added a new liability account named "Home Equity
Loan Account". It has a balance of approximately $15,000.
Even though I have cleared and rechecked the account names
in the reports section making sure that this new account
has been marked for inclusion, it doesn't appear on the
report. What corrective action should I investigate?
(Office XP Pro with 3rd Update and WINXP Pro)
After clicking "Send and Receive," I get a red "X" error
message "You don't have appropriate permission to perform
The account tests OK under the Tools-Email Accounts tab
This account used to work perfectly. This error occurred
some time ago now and I have never found a fix. I cannot
associate it with any particular change with my system.
WIN USER 1 - administrator account (Outlook works fine)
WIN USER 2 - limited account (Outlook gives the above
error but the email acct tests O....NET Framework 1.1 compatibility
Does anyone know when the CRM will support .NET Framework 1.1?
I have VS.NET 2003 installed on my development machine. There doesn't seem
to be a straightforward way of building a solution in 1.0 from the IDE. I
guess I can use the command lines...
Microsoft CRM v1.2
http://www.workopia.com/Links.htm >> Other Microsoft CRM
Online Forum Resources
>Does anyone know when the CRM will support .NET Framework
>I have VS.NET 2003 installed on my development machine.
There doesn't seem
>to be a straig...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.
...Exchange SVC Pack 1
DO NOT INSTALL. It crashed my server and caused the stores to unload and
crash frequently. Now Microsoft want to sell me a hotfix.
It was working b4 the svc pack upgrade so everyone beware!!
Er, no, that's not the case at all.
Exchange 2003 SP1 works perfectly fine for a large number of customers.
If you, as a Microsoft customer have had an issue with the SP that requires
a service pack, identified by Microsoft, then you will not be required to pay
If you have a KB that says you are to call MS for the fix then you may be
required to give details but you won't be char...