Can't get a 0 to show on the x-axis!
I am trying to chart a single line graph to show the variation in decibels
over a period of 600 seconds.
I am unable to get the category axis to show a 0 at the origin on the
x-axis - the best I can do is to show it at 1, 51, 101 etc.
If I try to change the value to 0 by formatting the axis I am told that the
value 0 is invalid.
Can anyone tell me how to get the x-axis scale starting from 0?
I am using Excel 2002 (SP3)
I have just discovered that I need to use an XY Scatter graph and not a Line
"Noel S Pamfree" <Noel.spamfree@hot...Reinstalling CRM 4.0 but preserving data
We are having terrible trouble having upgraded from CRM 3.0 to 4.0.
We are trying to use the Workflows to manage tasks etc., but without
fail the Workflow goes into a "Waiting for Resources" state and never
does anything. We've looked at all the obvious candidates (the Async
Service, for example) and have tried the various fixes (more
information here; http://www.themssforum.com/Crm/Workflows-Waiting/)
We're now at the stage of considering reinstalling CRM 4.0. However,
we have migrated a large amount of data from our CRM 3.0
installation. Can we safely backup the existi...OMNI Tools with GP9.0
I've read an article that says I cannot use OMNI Tools with GP9.0 anymore.
Can someone help me with this? I've purchased OMNI for login validations.
I'm using SQL2000
I originally developed Omni Tools which is now sold by
I would be interested to see this article as it is not correct. Omni
Password will still work with all versions of Great Plains/Dynamics GP and
all database versions.
You can even have it working along side the functionality offered by
Dynamics GP 9.0 with SQL Server 2005 and Windows Server 2003 and Active
Directory. Thi...multiple IF calculations
I've figured out how to make cell X display the number of hours entered into
D9 if the text "Stat Worked" appears in D11, but now I need to do the same
for columns E through Q, and sum the results.
=IF(D11="Stat worked", D9, 0)
> I've figured out how to make cell X display the number of hours entered into
> D9 if the text "Stat Worked" appears in D11, but now I need to do the same
> for columns E through Q, and sum the results.
> =IF(D11="Stat worked", D9, 0)
> Any thoug...New workstation, AMD Athlon 64, OK for GP 8.0?
We are getting ready to buy a new workstation and I want to make sure it is
ok with Great Plains V8.0. Is the 64bit compatiblity problems with the OS or
the processor? It seems like the majority of the workstations out there are
now 64bit. I am looking at a Dell Dimension E521 with an AMD Athlon 64 3200+
processor and XP Pro. We will be upgrading to 9.0 in the near future, but I
don't have plans to do this before buying this new workstation.
...Unable to uninstall CRM 3.0 client from any other user, including Admin (Local or Domain)
How do I uninstall CRM 3.0 client that was installed on another user
account we don't have access to?
The only way we can uninstall the client is if we log in as the user
who used it. When people switch computers and a new user needs that
computer, the only way to enable them to use CRM outlook client is to
uninstall it on the old user and reinstall on the new. Why!?
Any help is appreciated.
...RMS 2.0 #3
So if RMS 2.0 if ready for Shipping mid Jan, two questions . . .
1) When am I likely to get it in the UK?
2) What fantastic new features can I expect?
This is a multi-part message in MIME format.
1) How slowly do the boats take to get to the UK?
2) Fantastic? Umm. Useful, a couple/few. For whatever reason, they =
don't want us to mention anything publicly. If you subscribe to the =
Insights newsletter, I would probably...Outlook 2007 shows no pictures in HTML mail
Only red crosses.
Trustcenter is disabled but still no pictures.
Clicking 'Download pictures now' doesn't work neither.
...In Excel 2002 highlighted cells show when printed, not on screen though.
I cannot get Excel 2002 to show patterns or colors on the
screen. They print correctly on the printer. I have
checked options, and see nothing that seems
OFF: Changes to Fill Color and Fill Pattern Are Not Displayed
Read this KB
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"Borcherding" <firstname.lastname@example.org> wrote in message news:email@example.com...
> I cannot get Excel 2002 to show patterns or colors on the
> screen. They print...Office 2003
Since a few days ago, I have started to receive the warning shown below
every time I start Outlook. I have no idea where this comes from or how to
"This file contains macros with an expired or revoked signature. Since you
are running under high security level thse macros will be disabled"
I found the answer. It is the macro security setting in MS Office. What I
don't know is how it got changed from medium to high
"Jim McColl" <firstname.lastname@example.org> wrote in message
I need to populate a control on a form with the product of two other values
on the same form. I use a macro with a SetValue statement to do this, but am
getting a strange result on the calculation.
Rent = Cost*LeaseRate
Cost = $15615
LeaseRate = .0278
When I run the Setvalue macro, it results in Rent = $434.090 (I used the
Number, Decimal data type for all three numerical values).
Pull out a calculator. $15615*.0278 = 434.097
What????? Access is getting $434.090, correct value is $434.097 which would
round to $434.10.
This isn't just formatting or rounding, what's going on?
I...WARNING: Altering DBs in Access 2010 may make them not run under 2
I have multiple computers, and thought I would try the beta of Office 2010 on
2 of them, so uninstalled 2007 and installed 2010. On one of these machines
I made several changes to an Access DB. I then tried to open it on a machine
with Access 2007 and received an error message that it could not open the
file, that it was likely corrupt. It still opens fine on the beta machine,
as well as another machine with 2010 beta on it.
It may be related to 2010 eliminating MSCAL.OCX. I had to clear the
"missing" reference in references in VB as it is no longer supported (MS
...#DIV/0! error 12-06-09
I'm using the following formula =100%-(H6/J4) to get a percentage,
however result is #DIV/0! error
Can anybody help with this error?
Thanks for your help
If J4 is zero or blank, you'll get this error. Check to make sure there is a
value in that cell.
"Memo Larach" wrote:
> I'm using the following formula =100%-(H6/J4) to get a percentage,
> however result is #DIV/0! error
> Can anybody help with this error?
> Thanks for your help
Sorry, I forgot to add that if you still get the error even i...Autofilter shows no results, but there should be because there are matches
the column that I am trying to use autofilter on has nothing but
numbers in it. But when I do a custom filter for a number that begins
with '5' (for example), it shows no results. Even though there are
plenty of numbers that start with '5'. I do the same excercise on
another worksheet that is formatted the same, and it works fine. If I
go back to the non-working worksheet and retype the number in each
cell the autofilter will work. WHY OH WHY is this so?
That happened to me whenever I imported data from a particular database. On
import, somehow a little 1/2 space was put i...Set track = "All e-mail messages" in DB or bulk CRM4.0
I have a client who wants to change all users or a sub-set of users to track
all e-mail messages, but they don't want to have to go to each machine to do
it or log on as each user. Is there any SUPPORTED way to change it in bulk
(like a Group Policy type solution)?
I notice that changing the setting in the "Set Personal Options" window
updates two fields in the UserSettingsBase table:
I assume that changing these in SQL would be unsupported (and may cause
other problems). I also assume...New messages not showing in Inbox
We use Outlook 2002 SP2. On a couple of desktops we do not
see new messages showing up unless we open an existing
message. Once we close the existing message, all new items
are there. When we try to click the Send/Receive icon, it
does not bring the new items. The Outlook client seem to
contact the Exchange server only when we open an existing
item. Any thoughts? Thank you. P.
Could it be the 'views'? Did you change anything in the 'views'? Try
searching for 'Views' in the help file...
"P" <plavallee@rcn.......com> wrote in messa...Antigen 8.0 to 9.0 upgrade problem
I have recently upgraded Antigen version 8 to Antigen version 9. Version 8
had installed a folder into each user's mailbox folder named ASM Junk Mail
folder. With the upgrade ASM Junk Mail folder is no longer needed. How to I
go about removing the folder from all the user's mailbox. Is there a way to
systematically remove this empty folder? and making sure it doesn't reappear?
...M'03 not showing 2004 entries
I am creating transactions that are dated 2004. They show
in the reports... but not in the account register
(checking in this case)
My balance has gone totaly whack... off by thousands.
anybody else gettingthis with Money 2003?
Something very similiar is happening to me.
All my scheduled bills are showing up in the register,
BUT my scheduled deposits are not. This of course really
screws up the cash flow. This is only for transactions
scheduled for 2004.
What am I missing? There are no end dates to the
>I am creating tra...Updating GP 10.0 to SP2 genericPath error
I am trying to update a GP10.0 installation to the latest and greatest. When
I launch the MicrosoftDynamicsGP-KB952789-v10-ENU.msp package, it starts
working, then comes up with this error: Specified argument was out of the
range if valid values. Parameter name: genericPath. When I click "OK" the
install terminates. Any ideas?
I am doing a test install and had some problems so I am starting over. When
trying to unistall, I am getting the same error message. I have v10 sp3?
KB955679. It won't let me uninstall or do a repair install.
"Wes VanAlstyne" wrote:
>...Cannot make configuration changes in CRM 4.0 Outlook client
I've recently updated to CRM 4.0 from 3.0. After this upgrade, I am unable
to make configuration changes to my outlook client. I go to CRM->Options and
make the necessary changes, but when I click OK it just hangs and eventually
gives me a microsoft reporting pop-up message. Any ideas?
Do the users have enough rights? I found that if users did not have enought
rights the outlook client would work, but then would not let me change
options. Try adding a user the the System Administor role and trying again.
If it then works it means they are missing a right they need.
Un...Win CE 6.0 R3
How to implement Single SSID feature to my existing, working, USB WiFi
Is it the registry that need to be dealth with or is it the WZC app that
needs to be modified ?
Also dont want any popup WZC when system starts. It should directly connect
to the SSID we pre-designate using Single SSID.
Any tips will help
I don't know what "Single SSID" is. You could write a program that runs on
startup to check the preferred list of SSIDs associated with your wireless
adapter and, if there are none, add one that you describe...Print preview shows blank sheet
I am new at this but whenever I use print preview my work always comes up
but now for some reason all I get is a blank page and nothing prints out .
Possibly you have a print area set on a blank cell or cells. To clear
File, Print Area, Clear Print Area
OR to set a range to print:
Highlight the range you want printed:
File, Print Area, Set Print Area
"gillygalloo" <email@example.com> wrote in message
news:76E02D70-4D0A-4421-8B09-A4EF93642BFD@microsoft.com......Inbound email activites show up in Assigned or In-progress as completed and can't be removed
I have an issue with the International English version of CRM (1.2).
In my Workplace new inbound email shows up in my Assigned folder. I
can then re-assign or accept, but as the email is completed it can't
It is the same if I accept the email. It is moved to my In-Progress
folder, but I do not have the ability to move it from my queue.
I though this was by design and when the regarding Case was closed
these activities would be removed then. However they still remain.
Has anyone seen this behaviour or it is really simple and I have just
If i understand you c...Calculations #4
when I am calculating my totals, my sum is more than what
is listed. How do I make the necessary changes to reflect
the correct sum.
This might describe your problem:
In article <firstname.lastname@example.org>,
"Jessica" <email@example.com> wrote:
> when I am calculating my totals, my sum is more than what
> is listed. How do I make the necessary changes to reflect
> the correct sum.
Thanks for such ...Opening .xls file "outside" Excel not showing
Hi all. This is kind of weard, but here it goes: when I open workbook from
Excel (file -> open) it works just fine, but... When I'm trying to open the
same workbook via "link", for example double clicking the file from windows
explorer -> Excel opens, but the file is not visible. And when I choose:
view -> full screen -> it comes visible. Do you have any idea what is wrong?
System is Win XP pro and Office XP.
This happens to all .xls files...
Try the following steps:
1. Exit Excel
2. From Start, Run. Enter the command: "excel...