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 ...find and replace, within workbook
Is there a registry hack excel, find and replace, within workbook
I do Ctrl-F to search and get to the Find and Replace dialogue box and
select in Excel 2003 SP2 the Options > > button. It will expand the dialogue
box a bit more.
After the expansion, it displays the three drop down fields and the two
check boxes. I would like to set it so it searches by default Within:
Workbook instead of Within: Sheet (the default).
I have multiple workbooks and would like to search for all of them.
Is there a registry hack to set to 0 or 1 that will change from Sheet to
Find and Replace Within: ...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 <firstname.lastname@example.org>,
...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 ...2007 multiple sheet printing
How do I print multiple sheets of labels in 2007? It worked fine in 2003.
> How do I print multiple sheets of labels in 2007?
> It worked fine in 2003.
File / Pirint...choose 'Multiple copies per sheet'...
enter the number of pages X the number of labels...
Example....5 pages of labels @ 30 labels per page...
Enter..... Number of copies = 150
J. Inzer MS-MVP
Digital Media Experience
This is not tech support
I am a volunteer
Solutions that work for
me may n...trouble printing entire workbook with different page layouts
I have a workbook with about 10 worksheets. Some are
setup to print "portrait" and some print "landscape". In
previous versions of Excel, I had no problem printing
this type of workbook - the pages work print according to
thje page setup for each worksheet. In Office XP the
landscape pages print in different layouts - some print
on 2 halves of portrait, others reduce to fit the page!
I have tried using the macro from Microsoft, but it
doesn't work. Does anybody have a solution that works?
The printing of workbooks, with some sheets set for portrait and others fo...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...Multiple Qualifiers
I am trying to do a Count to get the number of locations that have a total of
This is the incorrect formula:
desired answer would be 1, or 50%
Column F Column D
The second part of your column, according to your example should refer to
column D, not S.
But if the smaller numbers really are in S, then you need to examine both
columns and make sure the numbers are really numbers, and not text. Your
...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...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.
...transpose 3d cells to a column in single workbook
I would like to extract 3d cells from a set of worksheets into a single
column on another worksheet within the same workbook. How can I do this?
Insert a worksheet named Summary, then select the 3D range, and run the
MS Excel MVP
Dim mySht As Worksheet
Dim dataSht As Worksheet
Dim myRange As Range
Dim myCell As Range
Set dataSht = Worksheets("Summary")
Set myRange = Selection
For Each mySht In ActiveWindow.SelectedSheets
For Each myCell In mySht.Range(myRange.Address)
dataSht.Range("A65536").End(xlUp)(2).Value = _
N...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...how do i bring a visual basic form to the spread sheet?
I have created a form using teh developer tab in excel in vb. The problem
is anytime I want to access the form i need to go to the developer tab, click
on vb and run it frorm there. What I would like to do is to bring the form to
the spreadsheet so that I can run it directly from there. or better yet, be
able to run the form independently of the spreadhseet. is that a possibility?
Thanks a lot for your help,
add a button to the spreadsheet and attach the code
UserForm1.show 'or whatever the form name is
You will not be able to run the form independant of ...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 <email@example.com> 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..."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...WorkBooks In Separate Windows.
Always in the past when I have created a new Workbook, it opened in a
new Window, separate from the Workbook that was already open. Now, today,
for no reason that I'm aware of, Excel refuses to put the new Workbook in a
separate Window. It puts the new one in the same window, on top of the one
that was already open.
Did I state that clearly?? Do you know what I mean??
I cannot get the new Workbook into its own Window. I can split the
Window, so both Workbooks are visible, but that's not what I want. I want
the new Workbook in its own Window, totally separate...'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?...