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...'black hole' method for departed employees emails
We have implemented Neil Hobson 'black hole' method
for email addresses of departed employees. It works fine, no NDR's are
However I read in this blog comments by people saying that this collects
mail in the Badmail folder.
I don't see any mail in our Badmail folder and I wonder if I should be
Message tracking for such email messages ends with:
"Message submitted to caterogizer"
Any ideas ?
If your running Exchange 2003 SP1, the BadMail f...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...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?
I am liking Wave 4 but it would have been nice to have had the ability to
attach labels to emails.
...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
news:67...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...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...How do I add my Peoplepc email to Outlook email accounts?
I am new to Outlook- (Using Outlook 2003)I am trying to set up the accounts,
I can't access my Peoplepc email from outlook, I can't send email from any
account- it stays in the "outbox"
I tried to reconfigure the Peoplepc account and still no luck. I walked
thru the "set up new email account" and still no luck. Can anyone help?
"Seamore" <Seamore@discussions.microsoft.com> wrote in message
> I am new to Outlook- (Using Outlook 2003)I am trying to set up the
&...How to enable the email address to repeat when entering a email
The outlook email program will not automaticallly fill in the email address
of email address that I have previously used. How and where can I enable that
Depends on your Outlook version which you failed to mention. Since the
feature is enabled by default, I suspect you have other problems.
Clarify your post and provide more detail.
"Crash1234" <Crash1234@discussions.microsoft.com> wrote in message
> The outlook email program will not automaticallly fill in the email
&g...Organizational Settings in CRM 3.0
Is it possible to hide viewing of Organizational Settings from non System
...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...Size of excel work book is not full screen
The excel work I have been sent is not full screen (about 3/4 size). Clicking
on blue header does not make it full screen. It is not possble to stretch the
Maybe the workbook is protected with the windows option checked.
Tools|Protection|unprotect workbook (if that option is available)
You may need a password.
> The excel work I have been sent is not full screen (about 3/4 size). Clicking
> on blue header does not make it full screen. It is not possble to stretch the
> window either.
...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...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...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...2 further: capture Event from MS Web browser (shdocvw.dll) 2
Thanks for your guidence...
>Another way, as shown by Paul Dilaschia might work for you. He
>discussed it few years ago in MSDN:
>He simply subclasses the IE window and traps some messages. I suspect
>it will do what you are looking for.
I have looked that example it was something i was looking for... But
..... My primary concern is to display MS Office documents and PDF
document. I have tried to load such documents And they were loaded but
was getting crashed In d'tor.... ?
Another thing that als...Shipping document #2
I am using GP 10 with the Country/Region Selection as United States. Since I
have a peculiar requirement for shipping documents. I came to know regarding
German Shipping documents which will suit my requirement exactly, but it
requires Germany as Country/Region Selection.
Is there anyway to use this Germany shipping documents eventhough my
installation is United States? Anyone has that chunk file which will work in
United States installation?
Thanks in advance.
...Vista CRM 3.0 Desktop client
Can someone tell me where I can find the CRM 3.0 Desktop client which works
with Vista & Office 2007?
You can download it using the following link.
"circulent" <email@example.com> wrote in message
> Can someone tell me where I can find the CRM 3.0 Desktop client which
> with Vista & Office 2007?
...How works conflictresolution with the offline outlookclient and ms crm?
Does somebody know how the conflictresolution works if one ore more
offlineclients synchronise to the server. How does it work if diffrent
offlineclientds did some changes on the same field?
Does someone know a good description about this problem?
Consider a situation where a field has been changed.
1. Two offline clients making a change
2. One offline and the second online client making a change
when the client goes online the data present in the client is synchronised
and saved irrespective of the time when the last changes were made to the