Who knows a way to un-link those links in a sheet?
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
You can convert them to values.
If you have xl2002 (or higher???), you can edit|links|Break link.
In earlier versions, you can copy|paste special values.
And to help find those pesky links:
Bill Manville's findlink.zip from:
won...Upgragding to 1.2 to 1.3
Receiving the media on Monday. Any issues that I should be aware of? Pralell
dongle. Best, M
Why not wait til 1.3R due within the next couple of weeks?
Otherwise, backup your database and any customized reports and/or receipts.
If you get a license violation after the install, just unplug and re-plug in
Get Secure! - www.microsoft.com/security
You must be using Outlook Express or some other type of newsgroup reader to
see and download the file attachment. If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open wi...Upgrade from Standard to Professional
Does anyone know if it's possible to upgrade from MS CRM 1.2 Standard to MS
CRM 1.2 Professional ???
To my understanding it's just a license key that enables/disables
functionality, or am i wrong ??
You are correct. All it takes it to install the new license keys and assign
them to the appropriate users.
MVP - Microsoft CRM
On Wed, 30 Mar 2005 18:38:20 +0200, Edward van Nijmweegen
Does anyone know if it'...How do I track emails ONLY using tokens in CRM 4.0?
The pattern matching or "intelligent" matching of email content is
misapplying inbound emails to non-related cases. I want to turn this feature
OFF ASAP and return to ONLY tracking through tokens in the subject line. I
can turn OFF tokens but not the smart matching. A configuration option would
have been nice.
I think you turn on the tokens, and then your users have to use the option
to only track "E-mail messages in response to CRM e-mail" - that's how you
prevent CRM from using 'smart' matching.
"Forrest_Adam" <ForrestAd...ALL of my email is gone- getting error message as well
I am getting this message:
The message store has been corrupted by an application external to Windows
Mail. Windows Mail has been able to successfully recover from this
In addition ALL of my emails are gone.
Any suggestions on how I can recover them? And what I should do about the
Try running the various repair functions in
the WMUtil program: http://www.oehelp.com/WMUtil
If still no improvement, upgrade to Windows Live Mail:
It will automatically import all your WM data.
Gary VanderMolen, Microsoft MVP (Mai...Pocket PC Money 2004 Foreign currency sync #2
Anyone have a clue how to do it? It's a pain living in japan and not being
able to update the account I use most on my PPC. Especially since a lot of
places in japan don't give receipts, or if they do, they are likley to be in
japanese. I don't read japanese and trying to sort things out at the end of
the day is a pain, it's be much easier to just enter ther debit when I incur
The client only supports the home currency. A serious limitation.
"Serpent77" <Serpent77@discussions.microsoft.com> wrote in message
I'm getting the alert message below from WMI on a pretty regular basis. I'm
not sure what to do with the information. The Event viewer is not adding
anything that indicates a problem. Any ideas?
MAMAIL1 has reported a Error. Reported status is:
Queues - Error
Drives - Warning
Services - OK
Memory - OK
CPU - OK
what parameters have you set for alerting on the server?
"rockymtn" <firstname.lastname@example.org> wrote in message
> I'm getting the alert message below from WMI on a pretty regular basis.
> I'...CRM Field Names
Is there a list on field names that CRM creates in the database in order to
use them for setting up workflow?
...CRM 3.0 and CRM 4.0
We were implementing MSCRM for a very protential CRM customer (Education).
Even they haven't signed the contract but we already started developing on
the CRM 3.0, 3 weeks ago.
A lot of customisation + .NET developing required on the version 3 but now
we knew that we're reinventing the wheels as some of them will be already
built in the V4 which one will be realease very soon (Q1-2008?)
If we place order to MS now, we will receive the V4 earlier than Q1-2008,
but it is V4, not V3
So now we decided moving the developing on V4 directly because no guarantee
what we wer...Upgrade to Exchange 2000 SP1
I need to upgrade SP 1 on Exchange 2000, I know don't know to do it.
Thanks for your attention.
You should be looking into SP3 and the latest Roll-up.
If this is a single server download and install. I would make sure Badmail
is empty. Other than that nothing special in a single server enviroment
well other than making sure your AV is up to date. If your using ADC and
other stuff I'd r...OWA Issue #2
I have some internal and external client that can connect
to the owa side but get errors on the page which stops
them from accessing mail and vieng anything but the
All the clients are running eplorer 6 with all the
service packs. The look identical in every way
Sounds like there may be some issues with either the Security or Privacy options in Internet Options. I'd check the configuration of a working workstation then compare it against a workstation that isn't working. Also what what particular error message are they getting on that page?
>-----Original Messag...Outlook Express -- Very, very SLOW to delete message
Help -- what do I do?
In article <email@example.com>,
|Help -- what do I do?
This newsgroup is for support of Outlook
97/98/2000/2002/2003 from the Office suite of products. Outlook
Express is actually a separate program despite the similar name.
For help with your OE questions, try an OE newsgroup such as
microsoft.public.windows.inetexplorer.ie6_outlookexpress (for OE 6), or
an OE help website such as http://insideOE.tomsterdam.com. If you're
accessing the Microsoft newsgroups through the MS Product Support
Ser...Organizational Settings in CRM 3.0
Is it possible to hide viewing of Organizational Settings from non System
...error when reinstalling XP Pro
I have a Dell Latitude D620. That was having some issues with ethernet and
wireless connections. Nothing really found as fas as malware or viruses,
without updates of course. I tried to do a windows repair from the XP CD and
right when it shows starting windows to choose repair or install windows I
get a blue screen with the error... PCI.SYS-address F76130BF base at
F76000000 Date stamp 3B7D855C. I tried a few times and even set the BIOS to
minimal. Then I pulled the hard drive out and connected to another laptop
using a usb cradle, formated the drive and put it back in th...Outbox message cannot be sent
I have an address list of less than 30 people. Each time I use the list to
send a mail message it will not leave the inbox. The message that comes up
is as follows: The message could not be sent. The authentication setting
might not be correct for your outgoing e-mail [SMTP] server. For help solving
this problem, go to Help, search for "Troubleshoot Windows Live Mail", and
read the "I'm having problems sending e-mail" section. If you need help
determining the proper server settings, please contact your e-mail service
The rejected e-mail ad...CRM and MapPoint
I have a client that has MapPoint 2004. They would like to have the ability
to map all of their current clients in certain areas, also with the ability
to make indication of future growth in these same areas. Currently, they can
only map one facility at a time. They would like to be able to map all of
their existing and future facilities for a spcific service area on one map.
Does anyone know of a solution for accomplishing this?
Not a mappoint expert by any means but I think there are 2 choices:
1. Export data from CRM (can probably just use the excel export option)...borders #2
In a spreadsheet, we have placed "broken-line" borders in red to make them
stand out. What I want to do is to make those broken-line borders crawl
while the viewer is looking at the spreadsheet on the monitor. How can I
make that happen? I think they are called "running ants" or "crawling ants."
I think you mean "marching ants" which you see around a copied but not yet
Also called a "marquee" which is the proper name for it.
You cannot replicate this with borders unless you used VBA code which would
render your sh...Cannot access CRM homepage on another machine
I have installed CRM 1.2 on a Windows Server 2003 SP1 machine. I can
work with CRM on this machine using http://localhost. But when I try to
access the homepage on another computer by typing http://CRMserver or
http://IP address of CRM server I cannot access it.
Can anyone please tell what do I have to configure to access the
homepage on another machine?
Thanks and Regards,
How can I reset CRM database?
I create contacts, acounts, invoices, etc., and i want
You cannot reset the database. You could restore the database if you took a
backup before you started adding data. You can also go into the system and
start deleting records. Can I ask why you need to do this? Have you been
experimenting with CRM and now want to go to a live server?
Microsoft CRM MVP
"Ricardo" <firstname.lastname@example.org> wrote in mes...outlook express ME 5.0
Hi! My friend has a computer that we cannot delete any sent messages.
Everything else seems to work. He has messages from 2007 that need to be
deleted. Any help would be appreciate.
...Undelivered message for mail I didn't send
I'm starting to get some "undelivered mail" messages and the address that is
shown is one that I haven't sent mail to, EVER. What is wrong, and how do I
fix it? Thanks.
is it spam or legit mail? Spammers often forge the from address so it has a
better chance of getting through spam filters.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and...duplicate emails being sent #2
Runnign exchange sp2 on windows 2003 sp1. I ahve a user who complained that
she got an a duplicate email from another user. Both users are on the same
exchange server. When i look a message tracking and specify the user who sent
the duplicate email, i can see that there are two emails wit hthe same
subject and are going to the user who got the duplicate. When i look at the
user sent items who sent the duplicate, i only see one email being sent to
the user. So Message tracking is saying that there were two emails, but in
the users sent items i only see 1.
What can i do to try...HTML messages received as plain text
Whenever I send a message in HTML format and receive a
copy of it at my own inbox, it gets converted to plain
text. I can't seem to find the place where I specify the
default receive format or some other way to stop Outlook
2002 from converting my HTML format messages to plain
text. I can receive HTML messages from others, but when
I send one to myself as part of group e-mail, it always
...Shading and borders with CRichEditCtrl (RTF 1.x)
I'm using a RichEditCtrl (RTF 1.0) in a C++ application (VC6). I can
generate the appropriate RTF 'tags' for italic, bold, font-size,
color, superscript, etc., but I'm baffled how to generate 'tags' for
shading and borders.
I tried using Word-2003 to accomplish this formatting, save as RTF,
and open with WordPad, but the resulting file is quite large and I'm
confused trying to figure out what it is doing.
Using the rtf codes below, I want Line 6 to have a border, and Line 7
to be shaded. My expectation is that this file would load into
WordPad-XP with this formatt...Linear Trendline #2
Excel has created a linear trendline with its equations from the following
the equations are:
y = 2.1053x + 3.3158
R2 = 0.8681
I wonder if you can tell me how excel create this linear trendline from the
Thanks in advance.
Excel uses "ordinary least squares," i.e., matrix operations that yield
coefficients that minimize the sum of squared deviations.
For the simple linear case, the results are equivalent to the formulas in
Excel's Help for the INTERCEPT and SLOPE worksheet functions.
See Excel's Help fo...