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...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...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?
...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...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...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)...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...Organizational Settings in CRM 3.0
Is it possible to hide viewing of Organizational Settings from non System
...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" <email@example.com> 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...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...Value Axis Scale Change Problem #2
Thanks Jon - problem solved
dp_fulcher's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=969
View this thread: http://www.excelforum.com/showthread.php?threadid=27033
...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.
...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...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" <firstname.lastname@example.org> 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
"Hope...Mobile sync crashes Information Store service
WM5 sync produces a 9673 event to be logged, crashing the Information Store
service. Description in the event log:
An exception with code 0xc00000fd was thrown in module
C:\WINDOWS\system32\ntdll.dll; some parameters and their values were
<Exception address - 7e840fdb>. A significant section of the call stack is
in the data section.
Fully patched E2K3 SP2 on Win2K3 SP1
OWA works fine - well - while the IS is up, but OMA is broken somewhere...
Service restarts happily each time, and I've set the recovery options on the
service to restart after one minute, but my (inter...CRM registration can not be done!
After CRM installation and valid internet connection via LAN, I could
not succeed to register CRM 3.0. Is there anybody who had this problem
before and solve it??
When you fill in the registration details, if you specify the implementation
was done by a partner company, make sure you fill in data in all fields for
the partner company, otherwise the registration process can fail
David Jennaway - Microsoft Dynamics CRM MVP
> After CRM installation and valid internet connection via LAN, I could
> not succeed to registe...Migrating CRM to CRM
We had to delete the OU from the Active Directy, and now
cannot get to our data. Reading through the posts it
looks as though we have to use the DMF to convert our
data because of the GUIDs that are hard-coded in the
files. Unless someone knows of a utility that I can use
to change the GUIDs in the Active Directory - but we
tried a number of different things.
So, is there an easy method to import CRM data into CRM?
I tried using SQL DTS to the cdf_entities, but this is
like pulling teeth, and don't know if I am going to be
losing any data. Anyone have any insight into getti...OWA strange problem #2
I have a general mailbox that users access using outlook 2003 (internal) and
OWA (Exchange 2003) external.
If the message in the inbox, the external user can open it and save the
attachments with no problem.
If the message is moved to a sub folder withen the inbox, then the user
can't access some of the emails and some of the attachments as well. When
double click on the message, we get "page can't be found. HTTP Error 404 -
File or directory not found.
Internet Information Services (IIS)"
Yet, from outlook 2003, we can access this email fine and save the
attachments w...PDF's not traking in crm
when tracking a pdf file in CRM we get an error saying that we can not track
it. the files are small so it is not an issue with them being to big. we can
track other types of attachments with no problem. in the event viewer we get
an error with the event ID: 5983. i did a google on it and find a solution
for the old 3.0 version(which was to update to a later 3.0 version). we are
on 4.0 with the latest updates.
thanks for your help
There is a problem attaching an email which has an attachment with an '&' in
the file name. Could this be your problem?
"Tyler Ba...Crm grid error
I've created a custom entity called Billed hours and associated it to
the case entity (which is the parent). It doesn't allow me to open the
instance of the billed hours entity in the associated view and when i
select it and try to delete it, it says: "You must select one or more
records before you can perform this action". I'd appreciate any help :)