Quick Help with Excel Formula #2
I have a cell where i want to select one of 15 names, how do i click o
the cell and a drop down menu appears with all the names, so then i ca
select one and this appear in the cell?
Message posted from http://www.ExcelForum.com
Use data validation.
>I have a cell where i want to select one of 15 names,
how do i click on
>the cell and a drop down menu appears with all the
names, so then i can
>select one and this appear in the cell?
>Message posted from http://www.ExcelForum.com/
&...Removing last 5.5 server #2
I have a couple questions about removing my last 5.5 server. Everything is
moved to my new 2003 server, except that all internet email seems to be
leaving through my 5.5 IMC. When I shut down my 5.5 server no email leaves.
All inbound and internal email flows normally though. Is there a way to
force my 2003 servers to not use the 5.5 IMC?
Also are there any special steps I need to take to remove the 5.5 server?
delete the IMC, wait for that to replicate to the e2k3 server, then remove
the 5.5 server.
you can also run the internet connection wizard on e2k3 to create an SMTP
Conne...getting reporting services web service to work
The error I am getting is 'The selected report is not ready for viewing. The
report is still being rendered or a report snapshot is not available.
There are lots of answers on the web and I have tried alot of them including
obtaining extract space.
The error I am getting is:
" The report is still being rendered or a report snapshot is not available.
I am using using windows-authentication to the datasource, and I am
wondering if I am not setting up the pass-through properly on the
Thus to correc...Fix for file open/save problem
A recent Windows update has caused problems for many people in opening and
See the following for possible solutions:
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.excel.misc&mid=1fe358b1-c8eb-4...sites and services servers
I recently went into our AD site and services and noticed under servers
there are about 4 servers that havent been online for months. Is it safe to
just remove/delete them here? Also our licensing server is listing a dead
Wondering why it never showed anything in event log. This is a 2003 sp2
server in a small domain with 2 other DCs
You need to perform a metadata cleanup.
You can follow this article to change the licensing sever
http://technet.microsoft.com/en-us/library/cc...A question about thread,please help me #2
My program environment is .net2005.The partial code is shown as below:
void CfinalView::OnRButtonDblClk(UINT nFlags, CPoint point)
AfxBeginThread(RUNTI...Saving Files Problem
I have been using Excel at work to do simple spreadsheets. When I wan
to take some data home to enter, I saved this info on a 3.5 diskette
When I try to open it at work I get a message that this file cannot b
accesssed. I am using the same systems on both machines.( Excel 2000.)
The message says " the file is either read-only or you may be trying t
acess a read-only location. Or, the server the document is stored on i
Message posted from http://www.ExcelForum.com
Never work directly in Excel from/to a diskette. There are many documented
...Services don't start when server restarts.
The information store and MTA stacks services do not
start when server is restarted. How do I fix this
Check your Event Veiwer, any errors? What are the associated event id #'s.
John Oliver, Jr.
MCSE, MCT, CCNA, Exchange MVP
Microsoft Certified Partner
"Micah Pokorney" <firstname.lastname@example.org> wrote in message
> The information store and MTA stacks services do not
> start when server is restarted. How do I fix this
Is this a secret??
...password help #2
I have to access a file that hasn't been opened in 3
years. It is password protected and I have the password
written down. However when I type in the password it is
not accepted. I have tried the password in every
combination of upper & lower case letters but it still
won't let me in. Could upgrading my operating system and
version of Excel affect the password? I think when the
file was created I was running Win 98 and Office 97. Now
I have Win XP and Office 2002. I don't have a hard copy
of the info in this file so I'm kind of desprate. Any
help would be appr...CRM services (help!!!!)
I have CRM installed on a W2K3 SP1 box, member server
The CRM was installed to have the accompanying services run under the Domain
I know that in someway the authentication is tied into to AD, from doing
some reading up on CRM. Can I switch the services to run under the 'Local
System' acct. without any problems.
Reason being is that I have some KDC event ID 11 errors showing on my DC,
which state that there are duplicate SPN name associated with the server
running the CRM, and with further research found that the SPN names for the
server were also attached to the A...Problem with WMC for Win7 x64 -- live TV setup problem
When I try to setup WMC (Win7 x64) for live TV it goes through the
region setting question, then the zip code, then when it goes to
"configuring" it hangs. I got a tip to run "mcupdate.exe" from
another forum to overcome the hanging.
After is scans for channels it asks if ATSC digital is what I want (I
do, for OTA TV)... then comes this dreaded screen:
"TV setup has encountered a serious problem. Select Finish to exit,
then try again. If this problem persists, restart Windows Media
Center or the computer."
I&...Resolution for the compatibility issue in Microsoft Dynamics Retail Products after Windows XP Service Pack 3 or Windows Vista Service Pack 1 is installed
Microsoft has released a fix for the compatibility issue in Microsoft
Dynamics Retail Products after Windows XP Service Pack 3 or Windows Vista
Service Pack 1 is installed
The Microsoft Dynamics Retail Development team has identified problems when
Windows Vista Service Pack 1 (SP1) or Windows XP SP3 is installed. Running
these service packs, without the below fix installed, may cause data loss
in Microsoft Dynamics Retail Management System or Microsoft Dynamics -
Point of Sale datab...Pivot #2
I have a Pivot table and attached Pivot chart (all good so far). However,
there are three columns (drop column details here) which are the two columns
of data and a grand total column (showing the average of my two data columns)
When I turn it into a pivot chart it does not display the grand total column
as well (is there a way to do this). I have tried to go into the chart
options but these are locked.
I can copy and paste the results but this is a bit clumsy.
Any suggestions - any help greatly appreciated
PS using excel 2003
I have just purchased a new PC running Windows 7 Pro to replace my ageing
XP3 SP3 set-up.
I particularly purchased 7Pro so I could run a few of my older programmes in
XP Mode but, having read a few, not so good reviews, about this facility in 7
Pro I’m considering other options. As far as I can see, I have three choices:
1. Burn (my existing copy of) XP Pro to an external, bootable, hard drive
and load my older programmes onto it. I can then boot from this and work on
XP Pro as and when necessary (hopefully, as I’m running this off my new PC, I
should be able to see a...Why won't my 2 publication pages switch to 2-pg view as asked?
This is a brand new publication. It only has two pages to it. There is
hardly any content and NO web links.
But when I use the VIEW drop down menu and click that very first option
saying "Two-page spread", Microsoft Publisher does absolutely NOTHING!
No, not in print view ... i'm saying "nothing". Yes, I've restarted my
computer... all that.
Also, in the master page view many of the options are totally greyed-out.
Why doesn't microsoft just fix its software instead of adding new inefficient
You must have three or more pages to see a two-page ...Re-Downloading Contacts in Outlook from CRM
I need to re-download the contact from CRM to the Sales for Outlook Client.
What is the recommended way to do this if we want to completely setup a new
contact list in Outlook from the existing CRM.
not sure I am following you. CRM will download to outlook any contact you
can see when accessing crm through the web interface
please explain further
Microsoft CRM MVP
"Dynamic Networx" <DynamicNetworx@discussions.microsoft.com> wrote in
messag...Problems Setting Delegate Permissions
I'm getting the following error message with Outlook 2003 and Exchange Server
2003. Does anyone know how to repair this? This occurs everytime I try to set
Delegates for a user, or any user for that matter. I get to the point where I
have assigned a user the permissions and when I click OK, I get the following:
Microsoft Office Outlook
The Delegates settings were not saved correctly. Unable to activate
send-on-behalf-of list. You do not have sufficient permission to perform this
operation on this object.
Thanks for your help,
Can you explain how your AD environment is setup. Singl...Pivot Table Calculated Item #2
The Calculated Item selection is greyed out on the Pivot Tables/Formula drop
down menu. I have my cursor in a field that I want to calculate. What am I
If your pivot table is based on OLAP source data, you can't create
formulas. Could that be the problem?
> The Calculated Item selection is greyed out on the Pivot Tables/Formula drop
> down menu. I have my cursor in a field that I want to calculate. What am I
> doing wrong?
Excel FAQ, Tips & Book List
...Downloading .ofx statements
I have Windows 98, Money 2003 and IE6 loaded. I can
download automatic statements (e.g American Express) and I
can download Quicken Files. When I attempt to download a
statement for a financial institutions I get two error
The first is for path C:\WINDOWS\Local Settings\Temporary
the message states "The Windows Installer failed to
install the program associated with this file. Please
contact your system administrator." After clicking OK
The second message is for the same path. "Access to the
we are having exchange 5.5 server, its hard drive fails. i
have installed new server and restoed the backup but MTA
service is not starting. other Exchange Dirtocory, IS sA
is working anybody can suggest.
"azam" <email@example.com> wrote:
>we are having exchange 5.5 server, its hard drive fails. i
>have installed new server and restoed the backup but MTA
>service is not starting. other Exchange Dirtocory, IS sA
>is working anybody can suggest.
Check the application event log. There will be some ev...Sending email problem in windows mail
I can receive email on my Comcast connection but I cannot send emails.
Trouble shooting with Comcast indicate that the problem is not with Comcast.
What can I do to fix the problem? Error number is 0x800CCC79. My email
address is firstname.lastname@example.org. incoming POP3 server is mail.comcast.net.
outgoing SMTP is SMTP.comcast.net. My operating system is Vista.
You don't need to post your real e-mail address for the world to see, but
you do need to post the error message,'
Please post the error message in its entirety. You can left click on it...ole server error #2
When opening the organization chart in publisher 2000, now
that I have Office XP installed. I get an error message
"Publisher can launch or communicate with the ole server
program needed to complete this task"
This worked fine until upgrading to Office XP
Hi kevin boseley (email@example.com),
in the Microsoft� newsgroups
|| When opening the organization chart in publisher 2000, now
|| that I have Office XP installed. I get an error message
|| "Publisher can launch or communicate with the ole server
|| program needed to complete this task&...Template problem
Folks I have a simple template class that is used to send classes across a
network. It is very simple(see definition below). It compiles fine, however
I cannot link it into my project, all the methods are showing as unresolved
externals. i have tried to explictly link (adding the object to the link
line), however it ignores the object saying it is there already. By the way
I am using Visual C++ 6.0. Any suggestions would be greatly appreciated.
/* Generic ctor
/* ctor which wil...Service Scheduling MS CRM
There are some extremely knowledgeable people in here I am hoping some one
can help me.
Any help you can give me is appreciate. We will not mind paying for your
help if you are a freelancer and would spend time getting this to work for
We have an implementation of Microsoft CRM 3.0 and would like to use the
Service Scheduling to help us run our fleet of buses.
We have a fleet of 8 buses, 6 drivers and need to schedule them for a
variety of jobs. Each bus has a capacity of 20, 30 or 50. The buses can be
out of order and drivers can be on holiday or off sick.
We want to able ...