I have a single workbook with multiple worksheets. All link to eachother.
I would like to sort ALL the information at once. Can I do this?
example of gradebook:
I would like to put names in alphabetical order if I add a new student. I
have a sheet that is for Daily Participation, Attendance and Testing and want
to sort ALL information in each sheet.
...POP3 Account Confusion---Plz help
I am having Exchange 5.5 in my company.
We have outsourced our Web Server to some other company who manages it.
On that webserver we have POP accounts.
From there mails come to Exchange in our company.
I am a new comer.Plz first tell me why they have done so?
So during configuration of the MS Outlook for users what settings I need to
do so that email facility works fine. Please help in detail.
>I am having Exchange 5.5 in my company.
>We have outsourced our Web Server to some other company
who manages it.
>On that webserver we have POP accounts.
...I really need your help on Crystal Reports
I've a serious problem with Crystal Reports.
I've a crm server which on a local network (IP: 10.10.X.X). I can use the
web application through Internet with an IP like 62.210.X.X (it goes through
a router which do NAT).
The problem is that I'm not capable to see reports list in CRM when I access
the CRM through Internet (it works in the local network). I've this
particulary stupid message about lack ok license...
I already try the problem resolution in the Crystal FAQ unsuccesfully. The
router and the firwall let the port 6401 free.
I think it must be resolved...Help #30
I have a row of data that I need to find a minimum value and a maximum
value. That's done. Now, I have to delete both the minimum and maximum
values from the row. Can you tell me how to easily do this? I have a
larg :confused: e worksheet with many rows, so Edit+Find really won't
only1joal's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24589
View this thread: http://www.excelforum.com/showthread.php?threadid=381823
Assume data is in Sheet1, in row1 down
...Need help troubleshooting odd Exch behaviour
I need guidance in troubleshooting some odd issues that started yesterday.
They seem so unrelated, I have no idea even where to begin. I'm using
Exchange 2003sp2 on Server2k3, all Outlook clients are 2003, and I support
about 25 email users.
The *only* modifications I've made to Exchange were this Tuesday morning
past (8/1/06). The mailstore had dismounted because it had reached the
database size limit (25GB). I adjusted the new size limit to be 40GB and then
remounted the store, but did not restart the machine, or take any other
actions. About 24 hours ago I started ha...please help!!! Unable to delete emails
NAVCE deleted the edb.log file from my \exchsrvr
directory. We were able to do a hard restore to get it
back up but we have several emails in users inboxes that
cannot be opened. When you double-click the email you
get a 'can't open this item' error. It appears something
did not synch properly during the restore but my email is
now up and running. I personally have a couple dozen
emails in my inbox from 9am - 2pm yesterday that I cannot
open and get that message. How can I permanently delete
Getting them back would be nice but I don't want to ri...Need help with Network Packet filtering (IDS)
I need a network packet filtering SDK for Windows using which I'd be
able to sniff packets over the network and block them after
I need this for an Intrusion Detection system I'm planning to develop.
The SDK should provide me with APIs (no matter user mode or kernel
mode) to read incoming packets,
I'll do a content search over the packet data and decide whether the
packet should be dropped or forwarded ahead.
Due to shortage of time, I cannot opt for writing an NDIS Intermediate
driver on my own.
I've found the following 3 SDKs until now:
1. Wi...Help with HTML emails in outlook
Can someone describe the best and most reliable way to compose
and send an HTML email in outlook?
Outlook Express has an Import Text From File feature that regular Outlook
does not have.
Ideally, I would like to create an HTML email template and use that for the
email but I'm having
problems producing a method that is consistantly reliable.
Using MS Word Send to feature results in (crappy) HTML.
Copy and paste into an HTML formatted Outlook message does not include the
Note: This is for an internal disctribution. Not spam or email marketing.
Your help is greatly appre...How to export tasks ? pls help
How do i export and import tasks using MS outlook?
I did export of my mailbox and when i import it the task does not come?
Are tasks included when you run Import/Export Wizard using MS Outlook?
Jack Dorson <JackDorson@discussions.microsoft.com> typed:
> How do i export and import tasks using MS outlook?
> I did export of my mailbox and when i import it the task does not
> Are tasks included when you run Import/Export Wizard using MS Outlook?
Hi - this ...Head scratchin for hours.... Help with a formula please...
1 workbook-54 sheets. One sheet per week. On that sheet I need a way to track
state mileage. 48 states. might be in a state 6 or 7 times and the all of the
other states I am in then a running total for each state each week.....
tried the =INDEX(A2:B5,MATCH("AL",A2:B5,0),2) works great for one entry for a
state. When I enter more mileage for that state it only returns the fist
entry. I need it to total up the mileage for each state entry...
"Bill Needham" wrote:
> 1 workb...outlook wont print attachment details
We have a few copies of office 2003 here and all except one will print
the attachment details (ie file names) on the printout (ie when you
simply print an email in memo format)
I've searched high and low for an option or tickbox but I cant figure
out how to get it to work.......................HELP!!!
P.S. I've also tried running outlook in cleanviews and firstrun modes
with no success. :(
I guess this isn't a common problem then?? :(
...Pics in Pub 2000 docs are distorted when view in Pub 2003? Help?
Some pictures that are on pages in my Publisher 2000 documents are showing up
distorted when I open the document/file in Publisher 2003. Any ideas? These
are embedded pics. Thanks.
WordArt objects in a Publisher 2000 publication may appear distorted when opened in
Can you adjust the images? Or re-insert?
Mary Sauer MSFT MVP
"CLC" <CLC@discussions.microsoft.com> wrote in message
news:9CCE5A98-E8B3-4F...Publisher and PDF help...
I am trying to find a solution to my delima. I have publisher on one computer
and adobe acrobat on another. Is there a Publisher viewer or some work around
that anybody knows of.
Thanks in advance...
While in a state of ecstasy after repairing his laptop, Ed sees a
message from Neal <Neal@discussions.microsoft.com>. On it is written:
> I am trying to find a solution to my delima. I have publisher on one
> computer and adobe acrobat on another. Is there a Publisher viewer or
> some work around that anybody knows of.
a) Output a PostScript file from Publisher and di...anyone know of any excel irc help server's and rooms?
...Help with Exchange 5.5 Queue problem
Okay, first off, I inherited this Exchange server. It has been over 5 years
since I last touched one of these.
Client noticed that no e-mails were being sent out. I checked the IMC
queues and they were packed full of email going to .tw, .fr, .de, etc.
Disconnected the ethernet cable from the back of the box. Ran the much
needed virus check and got rid of 225 Netsky and Beagle viruses. Reran a
few times just to be on the safe side - server is clean (latest norton
updates). And made sure that relaying was also turned off - just for fun.
Cleaned out the queues (deleted the contents of the ...Browsers, file associations, content-types: HELP!!
I'm trying to understand how a regular windows application can be started
when the user clicks on a link to a particular filetype in a browser.
Background (in case its important)
I have a normal windows app which has registered its filetype (say ".xyz")
so that double-clicking on a ".xyz" file in Windows Explorer opens the
".xyz" document in my application. This is done by a few registry keys:
HKEY_CLASSES_ROOT/MyPrivate.Doc/shell/open/command "<path to app>"
(I've omit...help help help
I just installed Micosoft Office XP Professional with no
problem. However, whenever I try to perform any task
such as opening contacts area, I receive a dialog box
with Microsoft Outlook and a yellow exclamation point.
Also, included in the dialog box are the words could not
open the item, try again. Could you please tell me what
the problem might be and how to fix it?
Do you connect to an Exchange server or do you use a pst-file? When exactly
does it happen, when you try to open the Contacts folder from the folder
list? Was it a clean install or an upgrade?
Robert Sparnaaij [...rpc-https ISA 2004 help
I have an exchange 2003 sp1 running on server 2003 and it reside inside a
perimeter network. It is a single server entity...it is it's own DC, CA,
Exchange, DNS, GC.
I have ISA 2004 running on server 2003 sitting in front of the perimeter and
internal networks. I have port 25 allowed in to the Exchange server and an
SSL tunnel allowed to the Exchange server.
client: Outlook 2003 (XP-SP2)
When I run outlook /rpcdiag from inside either the perimeter or internal it
connects via HTTPS, but resolves the external FQDN for exchange to the
If I run OWA Externally I am fir...Help in a query
If i use this query:
select S.fam_code FAM, S.fam_nom NOME,
select sum(SB.vn_atelier)+sum(SB.vn_loja) from roa_stat01_det_f SB
where SB.dt>='20100101' and SB.dt<='20100104' and SB.fam_code=S.fam_code
from roa_stat01_det_f S
group by S.fam_code, S.fam_nom
order by 1
The result is the following:
01 LUBRUFICANTES 2805.6100
02 MANUTENCAO/REP. 2574.3900
03 ELECTRICIDADE 6298.5900
==========================================...formula help #14
I have a plethora of spreadsheets that I would like to
alter by adding specific text to all cells immediately to
the right of a cell with specific text. Example: For all
cells that read University of Maine I would like to add a
cell to its right that has the text "Black Bears Main Gym".
How do I get excel to do this for me without me going
through, finding all desired cells and adding the new info
Please help ASAP. Much appreciated!
"CJer" <email@example.com> wrote in message
news:199d201c41cd1$9cf91a50$...Please help #13
Hi, I have a talbe including two or more same name, I
want to make it from:
Please help, Thank you!
Dim iLastRow As Long
Dim i As Long
Dim j As Long
Dim sFormula As String
iLastRow = Cells(Rows.Count, "A").End(xlUp).Row
j = 0
For i = 1 To iLastRow
On Error Resume Next
iRow = Application.Match(Cells(i, "A").Value, Columns(3), 0)
If IsError(iRow) Then
j = j + 1
Cells(j, "C").Value = Cells(i, "A").Value
...Help With NDR #2
we have 1 mb limit on exchange.But we are not reciving ndr's when sending
more more than 1 Mb mail. In tracking logs we can able to find the mail with
ndr but with no sender for that mail.
On Mon, 29 May 2006 09:47:02 -0700, shailesh
>we have 1 mb limit on exchange.But we are not reciving ndr's when sending
>more more than 1 Mb mail. In tracking logs we can able to find the mail with
>ndr but with no sender for that mail.
Can I ask this another way?
You're sending a message that you know to be oversized but you'r...Need Help Converting over to Outlook From Express
OK, I have been using OE for about 2-3 years now for my Email and Newsgroup
reader. This past Christmas, I got a Pocket PC that came with Outlook 2002.
I plan to use t to be able to keep track of my appointments and such but I
would also like to use it as my new email reader. I also would like to use
it for newsgroups, if that's possible. Is there a way that I can transfer
all my settings, emails and newsgroup information over to Outlook or am I
forced to just start from scratch?
OL has no Newsreader capability. In OL News is accessed via the OE
newsreader as it is from...Need help moving Outlook folder
I'm using Outlook 2002.
My primary email account uses IMAP and I added it to
Outlook using <Tools> <Email Accounts ...> <Add a new
I noticed that Outlook created a file for this account in
C:\Documents and Settings\User\Local Settings\Application
This file obviously contains the email that has been
downloaded from my email account, since the file size
grows and shrinks as mail is added or deleted.
However, I would like to move this file from its default
location to another hard drive. The reason is that the
other ha...Help with a simple form #2
I need help with a very simple form. I have a glossary for my team defined
in Excel. I want to set up a form that will let them key in the first few
letters of either the acronym or the term itself and show all items in the
worksheet that start with those letters. As you key more letters, it refines
more. Kind of like the index function in Help.
Secondly, I want to set up an input form that a user would fill out that
would then save that information into a second spreadsheet (behind the look
up one). Then an administrator would review those entries regularly and add
the entries to...