Creating a summary from existing spreadsheet data ...
Looking for a solution to this little problem in Excel ...
Cells A1 to C7 contain the main data. What I would like to do is select all
of the items with a Condition of A and place them in a little summary as
shown in A9 to C12. Any ideas how to automate this please?
A B C
1 Pt No. Desc Condition
2 1 Apple A
3 2 Pear A
4 3 Banana B
5 4 Orange A
6 5 ...Exchange 2003 Categorizer errors
We just added a Exchange 2003 server to our Exchange 5.5 site. (We are
also running 2003 AD.) Periodically the Event Log shows the following
error messages when a user sends an email out. (All these users are
users of mailboxes that have been moved to the 2003 server.) The
message is delayed a little bit but it eventually gets to its
I can't find any docs on these error messages. Any Ideas?
Event Type: Warning
Event Source: MSExchangeTransport
Event Category: Categorizer
Event ID: 6010
Time: 10:20:18 AM
Cate...Database Backup Error
I was trying to do a backup of the database, but I got the following message
after naming the backup file and selecting an external device as the backup
Cannot open backup device C:\Documents and Settings\backroom\Desktop\b.bck.
Device error or device off-line.
See the SQL Server error log for more details. BACKUP DATABASE is
Is it possible that the this could be caused by the USB in the PC not being
a USB 2.0?
The first reason is that the MSSQLSERVER service is running under a separate
set of NT credentials - all services are related to an NT ...Text and Data for Axis Lables
Hi, I have a chart that I am working on and in it all of my X axis
lables are in my excel workbook except 1. How can I define the lables
using the data contained within my workbook and manually enter a text
lable for the one exception.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
You have to put them all into the worksheet. Could you just rearrange
the data to allow this?
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/...Exchange and BlackBerry's
Right now we are running exchange 2003 standard, and we have some black
berry's. The only way we can get email redirected to the black berry's is
to use the desktop redirecter. Is there some other way to do this that
doesn't require the desktop redirector?
yes...you can use the Blackberry Enterprise Server...
"James" <firstname.lastname@example.org> wrote in message
> Right now we are running exchange 2003 standard, and we have some black
> berry's. The only way we can get email redirected to the black berry...Outlook 2010 Beta and Exchange 2003
Specs: Windows 7 Pro on HP nw8440 laptop.
Does anyone know if Outlook 2010 Beta is compatible with Exchange 2003?
When I try to setup Outlook 2010 Beta I get the following error:
"The action cannot be completed. The connection to Microsoft Exchange
is unavailable. Outlook must be online or connected to complete the
connection". However I can ping the Exchange Server and I know it is
working as I can setup Outlook 2007 with no problem.
I have it working successfully here so yes. How are you configuring your
...Exchange 2003 Store.exe failure
Our Exchange Server 2003 recently exhibited the same issues as
described in Nicolas Harnois's post
The problem starts with the following error:
Event Type: Error
Event Source: Microsoft Exchange Server
Event Category: None
Event ID: 1000
Time: 3:43:10 AM
The description for Event ID ( 1000 ) in Source ( Microsoft Exchange
Server ) cannot be found. The local computer may not have the
necessary registr...Exchange server not showing quarantined attachments but users are
We recently upgraded to 2003 outlook. By default our Exchange server
quarantined attachments. We have corrected the problem and proper
attachments are no longer being quarantined (None are currently being
held). However ALL attachments for ALL users before the upgrade are
What do you mean by quarantined? Do you mean the attachments were blocked or
are you referring to an AV client.
"Jacob" <Jacob@discussions.microsoft.com> wrote in message
> We recently upgraded to 2003 o...Exchange server not responding
I can't get into my new outlook 2003. It is saying the
exchange server is unavailable. I don't know what to
write for the exchange server? Help
Ask your Exchange Admin - we would not know the server name.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Olivia asked:
| I can't get into my new outlook 2003. It is saying the
| exchange server is unavailab...Change the size of the data labels
How do I change the size of a data label in a pie chart? I am getting
unusable wrapping of text when I have plently of room if I could only resize
the label box. All I've been able to do is move the label.
Unfortunately, Excel does not trust its users to resize data labels, chart titles,
or axis titles. If you need this level of control, you need to replace the data
labels with text boxes.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> How do I change t...Exchange Server 5.5 #4
I have Exchange Server 5.5 SP4. I have configured the
mail connector not to allow relaying by selecting the
Routing tab, then selecting "Reroute incoming SMTP mail"
Then under Routing restrictions, I selected "Hosts and
clients that can succsesfully authenticate"
When I telnet to my Exchange server from an outside
source, I am still able to relay mail.
"Matt Fitz" <email@example.com> wrote:
>I have Exchange Server 5.5 SP4. I have configured the
>mail connector not to allow relaying by selecting the...how do i link spreadsheets on common data points?
I am trying to link two separate spreadsheets with one common data column.
We have been the targets of some kind of DOS attack in that a remote server
continually transmits a garbage message to <fictitious random
The main result is that before we figured what was going the Administrator
mailbox got clogged up with 1.4 million NDR's. Two queries:-
1) Anyone know a quick way to clear the Administrator mailbox. The Mailbox
Cleanup Wizard only does around 300 at a time then stops. Logging into the
mailbox -> select all hangs the system. Selecting more than around 4000 and
deleting gives a not enough memory error.
2) For...exchange 2003 SP1 #4
I would like to upgrade to SP1 plus the post SP1 hotfixes. Let me give a
brief summary of my environment and see if anyone knows of any issues I will
4 node (3 active/1 passive) cluster Mixed mode
2 front end servers (OWA and SMTP. No Pop, IMAP, or mobile devices)
1 server running Exchange 2003, ADC, and SRS
10 exchange 5.5 servers with a few mailboxes, public folder, conference
rooms, etc. left on them
-these will be going away in the next few months
2003 AD mixed Mode
Blackberry enterprise server version22.214.171.124
Sybari Antigen 8.00.1470
It seems I should :
1) backup every...Exchange 5.5 and Vodafone Text Centre
Exchange 5.5 SP4 on Windows 2000 server SP3
Outlook 2002/2003 on Windows XP SP1
Mailbox count = 150
Symantec AntiVirus installed and running on all servers and clients
with latest def files.
Our exchange server has been running really slow for past one week to
10 days. We have just dafraged the priv database last night but did not
resolve the issue.
After much digging around, it turns out that only two users are causing
the CPU to peg at above 60% when they open unread mail. The dreaded
"Requesting data from the mail server" comes up for these two users
whenever they open unread ma...How do I copy/paste subtotals without all the extra data?
I am trying to either do a vlookup or copy and paste the subtotals without
getting all the data in the hidden rows?
number of ways you can do this...i had the same question earlier.
1. highlight the subtotals results that you want to copy. hit F5
special and "visible cells only" then ctrl C, which sould highligh
with white lines the subtotals you want to copy. then ctrl V t
wherever you want. it'll get rid of all the data in the hidden row
and leave only the subtotal results.
2. copy and paste from Excel into Word and back again. That should d
3. Copy a...What is the meaning of error
I ported my .mdb project to .adp, but now I get that message when I try to
save a record from a form. Anyone know the cause?
I'm experiencing the same problem, which is really nasty because it happens
sometimes and sometimes not. After receiving the error (#1020) "column data
is unavailable" MS-Access crashes and generates a problem report (Access 2002
SP3 with MSDE SP4 on Windows XP SP2). I reduced the problem to one form with
3 fields and one table as the data source for the form - nothing complex -
entering a couple of values and Access crashes again.
I hope somebody ...Remove Data From Field
I have records in a TABLE that look like the following:
Jklebowski (Logged Out)
lawilliams (Logged Out)
I am looking for a way (within a QUERY) to remove the (Logged Out) from each
If it helps at all....The words (Logged Out) are always at the END of the
record....and always follows the Username and a single space
Can anyone help me with the syntax required to eliminated this "piece" of
Lookup the Split() function. Split the field at the "(" character.
HTH - Bob
>I have records in a TAB...Exchange Explorer 'Server not avalible' error
Hello, I have just installed sdk dev tools for exchange so that I can add a
script to a mailbox to export .zip files on my exchange 2003 server.
I have the script but when I run the Exchange Exploer and try to connect
using my administrator account and pass and the
I get the below error after I say yes to the message 'This page is accessing
information that is not under it's control. This poses a security risk. Do
you want to continue.'
'Server not available or a unrecoverable ...Lose data when copy and paste from workbook to workbook
When I do a simple copy and paste of multiple or even 1 cell from a sheet in one workbook to a sheet in another workbook, the data gets cut off - only the first part is pasted. These cells do have quite a bit of text and the cells with limited data seem to paste okay. The cell format is General. Any suggestions???
What version of excel are you using? There are limitations
on the number of characters a cell can have.
>When I do a simple copy and paste of multiple or even 1
cell from a sheet in one workbook to a sheet in another
workbook,...Additional Exchange Mailbox downloads emails again everyday
Operating System: Mac OS X 10.5 (Leopard)
Email Client: Exchange
Hi All <br>
I have a problem whereby an additional exchange mailbox downloads emails again everyday. <br>
The machine it is on is unique in the fact that the user is a pa and has 6 or 7 extra email accounts she looks after. So there is quite a lot of work for Entourage to do. <br>
So far the problem happens to others but the regularity seems localized to this mac. <br><br>Any suggestions would be greatly appreciated. <br>
...Slow Searching in Exchange 2003
We run an E-Bay business, the email box used for sales has about 80,000
messages for the past six months. Anything older is archived, but due to the
volume of the emails, and the nature of business, this cannot be reduced
past the six months.
Searching is extremely slow, 4-5 min per search, so I looking for a soultion
for Exchange 2003. I read about Full Text Indexing and third-party utilities
that would help me, but not sure which one to go with. Clearly Exchange's
Indexing would be cheaper, but it add to CPU overhead.
Does anybody have experience on Full Text Indexing and what impoveme...scatterplot of data with gaps
I'm trying to plot a lot of data with gaps in the columns (empty cells) and
would like to be able to plot the series with points omitted if either x or y
are zero. It seems that Excel, rather than assume that a blank cell is zero,
stops plotting there... Can anyone help me with this?
Even assuming zero values would be better...
In a scatter chart, if X or Y are zero, there is no point plotted for
that data pair. Shouldn't be zero unless you go to Tools menu > Options
> Chart tab, and specifically choose to plot empty cells as zero. Of
course,...A search macro with search data stored in a separate TXT file
I need a macro that will help me do some editor's checks in an MS Word
Can you help me write one because this is too complex for my
1. The macro must start from the cursor position and do a search (and
replace in certain cases).
2. The data that will feed the search field will be stored in a txt
file located in the same folder as the Word file. Each line contains
the search data, a separator "|" and a replace data after the
separator. If there is nothing after the separator, then no
replacement is needed and th...Replication Issues between Exchange 2003 and Exchange 5.5
We have recently installed exchange 2003 server on our network and are
in the process of migrating users mailboxes. We have migrated 23
mailboxes so far, the first few were done individualy then a group of
about 8 users were migrated, the move wizard started moving four of
the eight mailboxes and scheduled the others, this failed initialy as
a user was still logged in to Outlook. The process was repeated and
Now from the client side in Outlook it is showing as the new exchange
server but the users are not recieving mail, the last copy in the
inboxes is from before the mi...