Count / Frequency #2
Thank you for reply, formula works well.
I just tweaked the cell referencing:
so that it counted 1 from my top most cell; i.e C19 (criteria), so
didn't need the +1.
However, How can I get this Formula to work on Filtered Rows: so tha
COUNTIF sequentially counts ONLY the Filtered Visible Cells (and doe
not include the non-filtered data)?
> the top row gets a 1 in column B
> then place this in the 2nd row in column B
> (this assumes the top row is 5)
> copy down col...Row limit in Excel #2
Is there a row limitation in Excel ? Reason why I ask, I have a control that
reads rows out of a Database. I have the option of creating this report by
dates. With one date, it will yield 5965 rows and I can open up that report.
Now with just the next day's date, it will yield 6060 rows and the Excel
file will be created, but it encounters a Microsoft error. There is no
difference in the data. I can in fact make the dates shift and include the
date range that was failing but it wouldn't go to the current - i.e.
4/23/2004 to 3/29/05 will fail but 4/24/05 - 03/29/05 will wor...Send as permission #6
I gave Win2003 SP1+Exchange SP2 with all the updates.
Some of the users have more than one mailbox.
To the emails in the other mailboxes its ok, but to send from this mailboxes
it says that there is no permission.
Where should I give the permission?
In the user's rights grant Send As right. It's not in the mailbox rights,
but in the rights on the user object.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"S" <firstname.lastname@example.org> wrote in message news:OxT4ELPHHHA.1240@TK2MSFTNGP03.phx.gbl...
...Creating a Mailbox
Is it possible to create a mailbox within the Exchange System Manager, eg,
email@example.com without having to create a user.
Im currently using exchange 2003
Not really. What is the problem?
> Hi all,
> Is it possible to create a mailbox within the Exchange System Manager, eg,
> firstname.lastname@example.org without having to create a user.
> Im currently using exchange 2003
You cannot create a mailbox in Exchange 2003 without creating a user account
associated with it.
However, if you just want an SMTP ad...Send/Receive at Startup #2
In Outlook 2003 is there any way to eliminate sending and receiving
automatically at program startup?
untick were appropriate
"Ron" <email@example.com> wrote in message
> In Outlook 2003 is there any way to eliminate sending and receiving
> automatically at program startup?
> Ron Gaynor
> South Garolina
"Ron" <firstname.lastname@example.org> wrote in message
> In Outlook 20...User explicitly denied "Full Mailbox Access"
I have an administrator account "Mark" that is explicitly denied the Full
Mailbox Access permission in "Mailbox Rights". I am able to grant other
adminstrators access to the same mailbox, even domain users. It seem the user
is inheriting the single Deny permission, but I can't see where from. The
user who's mailbox I am trying to grant access to is the domain\users OU.
Mark is automatically denied full mailbox access to all users, even if I turn
off inheritance in the security tab. Help?
Thanks everyone in advance.
Is his account listed in the exchange deleg...Need Help Programming #2
Yes, I want to use a variable inflation rates.
I don't want to see each years figure.
If I was using a calculator, I would do 100*1.03*1.03*1.03*1.03*1.03,
if I was doing that for 5 years and then I want to store that value i
I don't want any cells to have fixed values.
My material of var.
My percent is var.
My number of years if var.
> If you want to see each year's figure:
> Put 1995, 1996,..... across row 1
> In A2 put 100
> In B2 put =A2*1.03
> Copy across row 2.
> Format the row as currency.
> Yo...ondraw #2
I have MFC app that keeps calling ondraw over and over upon resizing of
the window holding a cveiw object. This occurs on maximize and restore
and when I resize the window.
I put in a static counter and it is definitely the calls to ondraw
If I execute onleftclick (overridden in the view) the calls stop and
the program acts normaly until I resize.
this cview has many listboxes created dynamically if I delete the
create function for the list boxes, the problem does not occur.
...2 Contact folders #2
I have 2 Contact folders named A and B. When I click To.. folder A opens.
How do I make folder B open first?
Set that option in your address book view: Tools > Options
"Invalid" <email@example.com> wrote in message
>I have 2 Contact folders named A and B. When I click To.. folder A opens.
> How do I make folder B open first?
"Russ Valentine [MVP-Outlook]" <firstname.lastname@example.org> wrote in news:477266CE-
> Set that opt...Resources #2
In Exchange 2003 how do I create resources for rooms, projectors, etc. that
people can use when scheduling meetings?
They are simply mailboxes.
Check out http://www.swinc.com/erm.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"David Mendes" <email@example.com> wrote in message
> In Exchange 2003 how do I create resources for rooms, projectors, etc.
> that people can use when scheduling meetings?
Can anyone point me to any info on the size limitations
for mailboxes & PST files..? I believe that beyond 2 GB MS
says you're in a danger zone. I need further info to
support our e-mail deletion policy
PSTs have a limit of 2GB (corruption may happen even after 1GB). Mailboxes,
on the other hand can be in the GB (but I wouldn't recommend it from an
Comsphere - "Where Knowledge Transfer is Key"
"Mikeg"...How do I set CAS permission for a single exe file
Assume that I have an exe file called MyExe.exe and I want to run this on my
computer with the permission in the permissionset MyPermissionSet how do I
best accomplish this ?
...mailbox split during mailbox move :(
If the mailbox move process dies in the middle of the mailbox and there is
half of the mailbox on the new server and the other half on the old server.
Is it possible to connect those two again?
I had one of my mailboxes do this to me on my test domain and I ended up
deleting (Purging) it since it wouldn't let me do anything with the part that
was left on the source server. I am just wandering what if it would happen on
my live server... do I have to bring the mailbox from .PST file or there is
Thank you in advance.
On Wed, 31 May 2006 09:49:02 -0700, Volodymyr <vg@a...A program is trying to access e-mail addresses you have stored in Outlook. #2
Every time my Outlook starts up I get a message that says:
"A program is trying to access e-mail addresses you have stored in Outlook.
Do you want to allow this?"
In the same dialog I get an option to allow this access for a period of time
(default is one minute). My question is "how can I tell which program is
trying to do this? I have Starfish (sync up with Motorola cell phone) and
MapPoint installed. Can it be one of these? How can I be sure it is not a
virus or a worm that is trying to do this?
Did you notice it started right after you installed a new program, or did it ...Is there a fle associated with additional mailboxes?
Is there a fle associated with additional mailboxes? Is there a file
that keeps track of additional mailboxes that I have access to and are
displayed in my outlook folder list? I want to know for migration
reasons. Once migrated will I have to add the mailboxes again or is
there a file that can be copied or even a utility that will make sure
I do not lose any. I only have a few, but some of my co-workers are
connected to as many as 15-20 I believe. Thanks for any help
They are part of the profile and stored in the registry. See
http://www.slipstick.com/outlook/mru.htm - I don't rec...The set of folders could not be opened. #2
Using Outlook 2003, with latest Office updates applied and using WinXP. I am
getting the following error message:
"Cannot start Microsoft Office Outlook. Unable to open the Outlook window.
The set of folders could not be opened. The server is not available. Contact
your administrator if this condition persists."
This happens about once on a daily basis. This is what I am doing to get
over it right now - once this message comes up, I re-boot
(Start-Shutdown-Restart) my machine and everything works fine after the
re-boot. If I just Log Off instead of restarting the computer, the prob...Watermark #2
I know I have seen this before, so please excuse me for
asking again. How is a watermark inserted into an excel
Thank You in Advance for your help.
You can use Word Art, remove the lines, color with 25% gray, click
semi-transparent (or in latest version set the transparency to your desire).
Rotate to desired angle. On the screen, when you type over the mark, it
looks a bit fuzzy but prints out wonderfully
If you have many to do try this:
Here is some code from L. Howard Kittle.
In this Zip file you can find 4 example workbooks with code to insert watermarks in to yo...column labels #2
My excel columns are labeled with numbers instead of
letters. Can anyone help me change the labels back
Go to the Tools menu and choose Options then the General tab. There,
uncheck the "R1C1 reference style" setting.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Dawn" <firstname.lastname@example.org> wrote in message
> My excel columns are labeled with numbers instead of
> letters. Can anyone help me change the labels back
> i...Read Only access to mailbox?
I know that in Active Directory you can grant someon 'Full mailbox access' to
another person's mailbox. Can you give Read Only access to another person's
mailbox in AD, or do you have to do that through Outlook permissions with
delegates or folder permissions?
On Tue, 26 Apr 2005 08:00:04 -0700, SilverICE
>I know that in Active Directory you can grant someon 'Full mailbox access' to
>another person's mailbox. Can you give Read Only access to another person's
>mailbox in AD, or do you h...email notifications #2
Is there any way to get a notification sent to my mailbox when there is a
problem sending or receivng email on Exchange server 2003
if there's a problem sending or receiving email on your server, that could
be due to many things, but most of the reasons would also prohibit your
receiving a notification email that something was wrong...
Susan Conkey [MVP]
"Dave" <Dave@discussions.microsoft.com> wrote in message
> Is there any way to get a notification sent to my mailbox when there is a
> problem sendin...You do not have permission to send to this recipient #14
This is a multi-part message in MIME format.
I randomly get an issue where a user will try to send an email to =
somebody and gets this message from the System Admin:=20
Your message did not reach some or all of the intended recipients.
Subject: RE: BBHS
Sent: 9/21/2006 10:13 AM
The following recipient(s) could not be reached:
Brendan Murray on 9/21/2006 10:12 AM
You do n...[OT] 1GB mailbox
i have find this site that offer 1 gb of space!!
"MMC" <email@example.com> said
> i have find this site that offer 1 gb of space!!
> it's wonderful!
Since installing my SAN I now have a 10TB mailbox to play with.
Andrew Mitchell <firstname.lastname@example.org> wrote in
> No thanks.
> Since installing my SAN I now have a 10TB mailbox to play with.
I use Veritas Backup Exec to performa backups of our information stores and
user mailboxes. During the course of the backups I get warnings from some
mailboxes about e-mails that are corrupt.
My question is, how do I get to the e-mail/mailbox level to find out what is
wrong with the particular message and if need be, eliminate them?
Bill Van Loon wrote:
> I use Veritas Backup Exec to performa backups of our information stores and
> user mailboxes. During the course of the backups I get warnings from some
> mailboxes about e-...cannot delete mailbox in 5.5
when i try to delete a mailbox i get the following error: "failure to delete
mailbox" event id is 1203. it suggests to stop and re-start the services, but
that does not correct the issue. any suggestion on how to remove the mailbox
that is not needed?
Any help from
> when i try to delete a mailbox i get the following error: "failure to delete
> mailbox" event id is 1203. it suggests to stop and re-start the services, but
> that does not correct the issue. any suggestion on how ...