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...Documentation on Dynamics application object
I am accessing the Dynamics application object (Dynamics.Application) from
VBA and am looking for documentation on the usage of parameters to the
Where can I find the documentation for this method as well as for the object
I think you're looking at an object in the Continuum API. If you check your Great Plains CD (CD2 I believe), you'll find Continuum API documentation in PDF format. The Application object should be described there.
"Reid Hopkins" wrote:
> I am accessing the Dynamics application object (Dynamics.App...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...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...Outlook 2003 hangs when checking Exchange credentials
I signed up for a hosted exchange service but couldn't get Outlook to
connect to the Exchange server. I spent 3 hours on the phone testing
lots of stuff with the support guys and we both determined that it had
something to do with my connection to the server. I installed Outlook
on a test computer on my network and it works fine. The only
difference between the two computers is that I am running Spybot on my
computer and not on the test computer. I shut down Spybot and still no
luck. I am an Exchange newbie so any help would be greatly
...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 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...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...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...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...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...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" <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...outlook 2003 page setup
when i send e-mail they are sent as a page with the text in lines as it
should be. the recipients receive them as just a long line of text. how do i
Are you sending the mail in Plain Text or HTML?
"seanpaul99" <email@example.com> wrote in message
> when i send e-mail they are sent as a page with the text in lines as it
> should be. the recipients receive them as just a long line of text. how do
> correct this?
"Vince Aver...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...