How do I get a Data validation list to select another validation l
I am creating a data entry page in which I want to use data validation Lists
to select the product that I want to enter. How ever each cell may be
different from the one above. For example in (c4) I want to enter pipe data.
I have a sheet named pipe as the source for this entry. In (c5) I want to
enter valve data or maybe pipe data or ell data. How can I use Excel to
create a drop down list that lets me decide which source page I want to use
and then go to it for me to make my selection?
Look at this site:
"langston35&...Unable to open Outlook2003. Error: MAPI unable loading msncon.dll
I am trying to set up Outlook 2003 on home computer but keep getting the
following message when trying to open application.
MAPI was unable to load the information service msncon.dll.
Since I am not open to open, I cannot get to the help feature.
Have you downloaded the latest MSN Connector from their site? Or, if not
using it, have you uninstalled it? Try opening Outlook in Safe mode
(start->run->outlook.exe /safe) and go into the Advanced options and uncheck
it from add-in manager or COM add-ins.
Milly Staples [MVP - Outlook]
Post all replies to the group to ...Random Selection Macro
I need to write a macro that randomly selects 1000 users
from an excel workbook. The workbook contains four
spreadsheets. Once these users are selected it then sends
them an email. Please help me.
What are you trying to do? Write a virus that is sent to 1000 random
See the Excel | Tutorials | 'Random Selection' page of my web site for
Tushar Mehta, MS MVP -- Excel
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <email@example.com>,
...Unable to Edit/Add records on Form in a New ADP
I just started playing around with rebuilding a MDB file as an ADP. I built
a form and subform from scratch, but I'm unable to edit or add records.
SELECT Id, LoadDate, TrailerDOTNumber, SealNumber, SealDate, SealId,
LoadLocation, LoadStatus, DispatchStatus, DispatchLocationId, DispatchUserId
FROM TrailerActivityHeaders ORDER BY LoadDate
Recordset Type: Updatable Snapshot
I'm getting the 'This recordset is not updatable'
Never mind... (Does anyone have a spare bandage btw? I cut my head banging
it on the wall due to my stupidity...)
"D...Unable to open calendar
Folks, i cannot open or view my calendar.
When I start Oultook a Pop Up appears saying "Could not read the Calendar"
On clicking Ok, the pop up vanishes and nothing happens.
If i then go over to my calendar, it says "Cannot display the folder"
I have run Oultook Diagnostics and nothing shows up as irregular. I ran the
repair function (off my setuo CD) and nothing happened. I also re-installed
Outlook and rebooted my comp and nada.
When staring in safe mode i also get he same errors.
I am using Off 2007, Win 7
"phamiltonsmith" <...unable to download emails and unable to stop synchronization
I am going to try one more time to get this fixed. My Outlook 2003 has been
unable to download emails. While it is trying, a small box in the tray
section shows up and it states that it is trying to synchronize folders.
After a time out time Outlook gives me errors. This is the error message. It
has these numbers 0X800CCC15 , or 0X8004210A, or 0X8004210B, which these
error messages state that either I did not have enough timeout or look and
see if server name is wrong. All of you have given me these suggestions. no
joy. Thank you very much however.
I went ahead and finally found a sect..."Play a selected sound" in "create Rule"
I want to use "create rule' "play a selected sound" to notify me of messages
from certain people. Screen is on "Create Rule" & "play a selected sound" is
not checked. The box beside "play a selected sound" says "chimes.wav"
When I check box for "play a selected sound" & do "Browse" to get to
'Control Panel' 'Sounds and Audio Devices', I get the message: 'The file
name, or format 'Control Panel" is not valid. Type the file name and
location in the correct format, such as...MS Mooney 2003 Freezes when pulldowns selected
I installed Money 2003 back in January. Ever since
that install I have problems with the application freezing
every time I select a pulldown menu - for example if I
try to split a transaction between multiple categories and
try to use the pull down to select the category the
application freezes, and I have to Crtl-Alt-Delete to
claose the application. I can close the application and
it will restart without rebooting the computer.
> I installed Money 2003 back in January. Ever since
>that install I have problems with the application ...How many virtual server Exchange supports?
In 4 nodes cluster environment, how many virtual server Exchange 2003
From 329208.KB.EN-US - XADM: Exchange Virtual Server Limitations on Exchange
2000 Clusters and
"Microsoft Exchange 2000 Server and Microsoft Exchange Server 2003 enforce
Active/Passive scenarios on Exchange clusters that have more than two nodes.
This means that on a four-node Exchange 2000 cluster or a four-node Exchange
2003 cluster, only three Exchange virtual servers can be created, and only
one Exchange virtual server can be hosted per node. "
Please do not send email ...unable to scroll the page
on microsoft office frontpage 2003 - when i up loaded my web pages to my web
site www.millertimeauction.com , there is no sroll bar for up & down of page -
it scrolls for me in IE8
scroll bar will only appear if it needs to
Microsoft MVP Expression Web
"FrontPage Error" <FrontPageError@discussions.microsoft.com> wrote in
> on microsoft office frontpage 2003 - when i up loaded my web pages to my
> s...Unable to start POP3, NNTP, IMAP4...
I'm evaluating to install Exchange 2003. After the installation I find the said protocol haven't been started. I tried to start
them in "Servers --> Server Name --> Protocols" but no help.
Please comment.... Thanks!!
Windows 2003, Exchange 2003, Active Directory DC with all roles of FSMO as it's the first DC in the forest. Thank you very much!!
Are you boring? Let's come to talk together... ^^
Those services are disabled by default in Exchange 2003. Go to
Administrative Tools, Services and enable...Why is my sort menu option disabled?
I exported a Crystal Report to Excel 2002, but when I try to sort the data,
the sort menu is greyed-out/disabled.
Anyone know why?
Thanks in advance!
Is the worksheet protected?
Do you have multiple worksheets selected/grouped?
Valerie M wrote:
> I exported a Crystal Report to Excel 2002, but when I try to sort the data,
> the sort menu is greyed-out/disabled.
> Anyone know why?
> Thanks in advance!
It is not protected, but I do have two worksheets, since it is 97000 records
I was finally able to get it to work by viewing the se...Unable to conect
I have set up my email account to work with aol using the guidlines for
outlook 2002 but it is still unable to connect. Any suggestions? Thanks.
John <John@discussions.microsoft.com> wrote:
> I have set up my email account to work with aol using the guidlines
> for outlook 2002 but it is still unable to connect. Any suggestions?
Since you pay AOL for their service, my suggestion is to ask AOL.
...OL 2003: Archive only selected subfolders
I used to be able to archive just selected subfolders in OL 2000,
although it was annoying to have to reset the autoarchive properties
in the main folder.
Now that I am using OL 2003, I am confused. It doesn't seem possible
(1) set auto-archive off for all folders
(2) turn on auto-archive for selected folders only.
If I got this to work again, I could cut my PST file size
dramatically. I'm not in imminent danger of hitting the dreaded 1.87
GB limit, but I do need to keep an eye on file size.
I live on Outlook <Private@privacy.org> wrote:
> I used to be able to a...Unable to click on charts & unable to create any new charts Excel
Just started using Microsoft Excel 2007 and I seem to have done something
that means the chart option is unavailable. The chart section is now grey
and all charts I have created are 'locked' I cannot click on them anywhere.
I'm working on a project and need it finished by Monday.
Do you mean that if you click on a chart it does not get a border to show it
is activated and there are no range-finder borders around the data that
makes the chart?
This is a bit odd.
Have you tried a new workbook to see if the problem is with just this one?
My advice with all odd things is...I am unable to send e-mails -unable to download files from IMAP.
I am so frustrated with this
ajmtextiles <firstname.lastname@example.org> typed:
> Please help.
> I am so frustrated with this
I can understand why you might be frustrated, but you've provided no useful
information for anyone to go on, so I doubt anyone can help you. When you
post in here, always include your version, SP level, and mode (if
applicable) of Outlook - you can find this information in Help | About. Also
include the type of mail account(s) you use and any other pertinent de...MSXML6 C++ unable to locate node
Hi, I am new to using the MSXML functions in C++. I found this on MSDN as
an example of what I wanted to do,
I have tried a number of XPATH examples to try and retrieve the
"><Code>12455</Code>", but have been unable to do so. The MSDN example works
fine. So, I am wondering if it's a namespace issue?
Any help would be appreciated. Thanks. Jeff
I have changed the code as follows:
int _tmain(int argc, _TCHAR* argv)
CString sResponse = "<?xml version=\"1.0\" encoding=\"utf...How do I create a form in a worksheet with control option buttons.
I want to create a form from scratch but with option buttons and lists but
from the hlep function I can't figure out how to do this?
I have heard that forms built from scratch don't often come with option
buttons or lists and am assuming it is because excel would have no way to
know what it is you are intending to do. I am having the same difficulty...
are you talking userforms?
> I want to create a form from scratch but with option buttons and lists but
> from the hlep function I can't figure out how to do this?
Userform assistanc..."One or more of the selected senders could not be added to your blocked senders list"
Hey all. I get this when ever I try to killfile anyone at all, regardless of
who they are. I'm on OE6 in XP Home and this has only just started
happening. My KF only has a few spammers in it so I don't think it's full.
Does anyone know what's going on?
Ayatollah of rock 'n' roller wrote:
> Hey all. I get this when ever I try to killfile anyone at all, regardless of
> who they are. I'm on OE6 in XP Home and this has only just started
> happening. My KF only has a few spammers in it so I don't think it's full.
> Does anyone...'OWA was unable to get to your inbox'
OWA is working fine for everyone on my domain (and has been for years)
except for one person. When he logs in it gives the error mentioned above in
the subject line. I've checked his exchange account and it doesn't seem to
differ from anyone else's...
Does anyone know how to solve this problem?
Repost in an Exchange group as OWA is a function of Exchange, not Outlook.
When you do, include the Exchange/Windows versions, and SP-level for each.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (in...Unable to display the folder (have I lost my mail?)
I've just transferred all my mail from my mac via IMAP, and rather
laboriously set up all my rules to get all my mailing lists in separate
Outlook has just decided that it can't display the two biggest folders
because e:\documents and settings\administrator\local settings
\application data\microsoft\outlook\outlook.pst is in use and cannot be
accessed. The file does not exist.
I assume my mail is gone and I have to go and throw it at the IMAP
server again, but could anyone tell me why this has happened and how to
stop it from happening again?
Is this all on a Mac?...Displaying the label of the selected Option Button
Hi, in Word 2003, how can I display elesewhere in the doc the label
associated with the radio/option button that the user has selected? Has this
something to do with Fields? I can't seem to work out how to do it. Any
Can I suggest that you don't use activex controls in a document. They are
primarily intended for web page creation. Use instead check boxes - which
can emulate the action of radio buttons with the aid of macros. -
However to answer the question asked, radio buttons work in group...Unable to display
I using Ex2k. when i connect another mailbox in existing admin mailbox, it
give error while i click on that particular mailbox.
Unable to display the folder. The information store could not br opened:
Can anyone tell what exectally the problem, is this a permision or any thing
In Exchange 2000 an Exchange Full administrator does not have te right to open an other mailbox by default , you need to add these accounts (or groups) to the Information Store object and give the appropriate permissions (send as + read as
...editor options 2008 and Autocorrect
I know how to get to the AutoCorrect List and see my entires, but cannot
mkae it wrok in Outlook. I go to Button->Editor Options where there are three
listed... Popular, Proofing, and Advanced. I suspect that I need to check
Proofing but both Proofing and Advanced do not reospnd to clicks. It's like
they are dead. Ideas? Thanks - Neil
what version of outlook? Did you install outlook and word as part of one
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 20...Unable to close/delete Opporotunities
Running CRM 1.2 on W2k3 std. server and SQL2000 on a different w2k3 std.
The owner of an opportunity is trying to close it. The following message
appear on the screen: "There are are still active or draft quotes associated
with this opportunity. These must be closed before the opportunity can be
We have not configured the Fiscal Year for our CRM system, and thereby not
This has worked before, and I can't recall that we have made any changes to
the system since.
Another odd thing is: If an owner of an opportunity or the Administrator is