All Task bars gone How do I get them back?
All of a sudden the other day everything at the top of my screen disappeared.
I can load my word documents by searching my files and double clicking on
the name but I can not Open a document inside word. I have never seen
anything like this where all the buttons for using Word are gone. How do I
get them back.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
...Display As = File as & (address in parens)
I just moved all my contacts into a new .pst file (I'm using OL 2003) and
I USED TO have "Display As" show only the person's name, and not the
person's name PLUS the email address in parens as the default does.
In other words, default would show "JOHN SMITH (firstname.lastname@example.org)". But
when I created all those entries, I changed them to show only "JOHN SMITH".
In my new file, Outlook has changed all my "Display As" entries to the
default: name AND email address. It's not how I want it, so I'm hoping
there'...Highlighting the active row with special colour
Is there a macro that highlights the whole active row (not only the active
cell) that the cursor is in, in an Excel worksheet?
Highlight it in a particular colour, I meant... that would move along when I
would move the cursor onto another row....
"Raj Mazumdar" wrote:
> Hi there
> Is there a macro that highlights the whole active row (not only the active
> cell) that the cursor is in, in an Excel worksheet?
Private Sub Workshe...Messages stuck in Queue with status Active and eventually fail.
I have an exchange 2000 server with SP3. The scenario is this; Everything
has been functioning great except emailing to AOL, so I setup a smart host to
use our ISP's smtp server. Well, they are getting flagged as open relay and
the mail is rejected. So I had them setup a reverse dns lookup for our IP so
I could send mail directly.
I found a site that allows me to check RBL's and we came up good on about 25
of them, so we aren't black listed.
Now we can email aol users without any problems, but all of a sudden, I
can't get the server to deliver mail to other exchang...Money 2006 Investment Account balance display
I have two Investment Accounts (401k) in Money 2006 Deluxe. For some
reason, Money stopped displaying the account totals on the Account List
page. It used to show the account balances and the subtotal for all of my
investment accounts. Additionally, I now notice that each account now has a
second account with the same name, but has the word "Contributions" added in
parenthesis. This seems to be new as well. The data in the accounts still
seems alright. My investment subtotal on the Account list page shows a zero
balance and there is no balance listed for the accounts the...more than 65,536 rows
Is it possible to have more than 65,653 rows on a worksheet? The data I have does not fit on a normal sheet
Unfortunately, the maximum number of rows on a worksheet is 65,536 rows and
cannot be increased.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Harald Bock" <email@example.com> wrote in message
> Is it possible to have more than 65,653 rows on a worksheet? The data I
have does not...Tool bar anomaly
Operating System: Mac OS X 10.4 (Tiger)
My customized toolbar has a 'close' button that is 3 times the size of the button on other toolbars. Also, the left-hand shaded column for grabbing moving the toolbar has a colon (:) below the button. I don't know that get there. The toolbar works but it should look the others. <br><br>Any ideas? <br><br>Ronben
The toolbars you create yourself do have a larger close button. I assume
that's to help distinguish them from the built-in bars.
Likewise, the dots you see are act...Rows and Columns Settings Problem
How do you set rows and columns in a way that when you scrol
down/column you can always see a certain row(s)/column(s)
Message posted from http://www.ExcelForum.com
Check out XL Help for "Freeze Panes"
In article <JMorgan.firstname.lastname@example.org>,
JMorgan <<JMorgan.email@example.com>> wrote:
> How do you set rows and columns in a way that when you scroll
> down/column you can always see a certain row(s)/column(s).
Message posted from http://www.ExcelForum.com
...Project status roll down to budget status should be more flexible
It was suggested by support that I mention this to see if others would
benefit. We use Project Accounting and have templates that contain as many as
150 cost categories. When users change the status of the project from
"estimate" to "open", the application automatically opens all cost categories
in the budget. The users would like to be prompted for this roll down so that
they can only open the cost categories being used in the template. We want to
avoid using more templates because of the complexity that it creates. It
helps our end users when they go to the Busines...Minimizing Rows of with similar data
I am using Excel 2007.
I have 3 columns A, B, and C such as below:
TU10-10 TU10 Tungsten Satin Wedding Band
TU10-10.5 TU10 Tungsten Satin Wedding Band
TU10-11 TU10 Tungsten Satin Wedding Band
TU10-11.5 TU10 Tungsten Satin Wedding Band
TU10-12 TU10 Tungsten Satin Wedding Band
TU10-12.5 TU10 Tungsten Satin Wedding Band
TU10-13 TU10 Tungsten Satin Wedding Band
TU10-6 TU10 Tungsten Satin Wedding Band
TU10-6.5 TU10 Tungsten Satin Wedding Band
TU10-7 TU10 Tungsten Satin Wedding Band
TU10-7.5 TU10 Tungsten Satin Wedding Band
TU10-8 TU10 Tungsten Satin Wedding Band
TU10-8.5 TU10 Tung...Outlook Shortcut Bar
How can I create a 'Grocery List' shortcut on the shortcut
bar (left side of Outlook window) that will open a blank
list similar to 'Tasks'? I can create the actual
shortcut, but it's nothing but a duplicate of my 'Tasks'
list named 'Grocery List'. I went into the 'Grocery List'
list, selected all, and deleted 'em - and there went my
entire 'Tasks' list, too.
I'd also like to set up other shortcuts, like
separate 'Tasks' for home and work, or 'Parts Inventory'
(maybe linked directly to Excel). I can't...Outlook 2000
I'm having a strange Outlook issue and cannot figure it out for the life
of me. Our mail server is Exchange 5.5 (can't recall the SP right now),
and the Client is Outlook 2000 SR-1. The user can view his primary
email box without any troubles, but also has access to another Exchange
email box. He can view every folder in it except the Sent Items. The
error it returns is "Unable to display the folder". What's strange is
he can view the subfolder in Sent Items, no problem. I've configured
his email on a different PC, and everything shows up fine, so I know ...How do I filter rows based upon a column value
I have a spreadsheet that contains multiple agency id's in a column. When
generating reports, I would like to filter per agency and display only the
rows associated with that agency.
Is there a tutorial or sample on how to do this?
It sounds like you are looking for Data / Filter / AutoFilter. Have a look
here for some basics:
"Jack" <firstname.lastname@example.org> wrote in message
> I have a spreadsheet that contains multiple agency id's in a column. When
> generati...List all row source for all forms, reports etc.
I'm doing some work cleaning out old unused forms, reports and
queries. I have been going through each report in a database (There
are A LOT), determining its row source query, then marking it for
deletion. I will eventually end up going through and deleting all the
unused queries. As you can imagine this is time consuming, and I was
thinkg 'there must be a FASTER way"
Does anyone have a suggestion, or link to a pre-built function or
model that could assist me?
On Thu, 17 Jan 2008 22:14:18 -0800 (PST), Darragh <email@example.com>
>Hi...Returning Data from a third cell in same row that meets two other
I'm looking for a formula that will return a result from a cell on a same row
as two other cells that meet certain criteria. I'm sure there is a way to do
this but i am a novice at this kind of stuff and can't seem to figure it out.
For example i want a cell to = what is in column E when column A="36751" and
when column B="Total Returns" The spreadsheet has 55000 rows. there will
only be one instance where both these criteria are met. i want to use this
to create a seperate spreadsheet with just info i need and can update on a
thanks in ...Viewing multiple excell spreadsheets on the task bar
Why is it that when I have 3 or more excell spreadsheets open they are not
all listed on my task bar the only way I can get to them is by going to the
window button and selecting the one I want to see, I want to be able to ALT
TAB between them and they are not listing them for me in the task bar only
the current one I have open?
Are you using XP? Sounds like that feature of XP which groups several
windows of one application into one spot on the task bar. There may be a way
to shut this off in taskbar properties. Click on the task bar and select
...Embedded Pictures received from Others do not display in outlook.
I recently switched to Outlook from Outlook Express. When e-mails are
received with embedded pictures, they display properly in Outlook Express but
do not display at all in Outlook.
Is this related to a security setting in Outlook that I can change to allow
these pictures to be displayed?
Jim <Jim@discussions.microsoft.com> wrote:
> I recently switched to Outlook from Outlook Express. When e-mails are
> received with embedded pictures, they display properly in Outlook
> Express but do not display at all in Outlook.
> Is this related to a securi...How to get Row # in formula?
I have several rows with the same formula but they are seperated, in some
cases, by rows with other information to prevent me from just dragging a
formula down to other rows.
Ex. While in row 13: B13*C13+B13*D13+B13*E13
While in row 20: B20*C20+....
how can I write a formula to populate the "13" or "20" automatically for
whatever row I am in?
You may not be able to drag it, but if you copy row13 formula and go to row
20 it updates does it not?
"DaveR" <DaveR@discussions.microsoft.com> wrote ...count rows
I have two worksheets - sheet1 and sheet2.
Sheet1 is my main data which contains 7 colums (A-G) and number of rows
varies depend on data.
In sheet2 I have formula in Row1 (A1:G1) and I need to copy down the
formula to exactly the same number of rows in Sheet1. (For eg: if my
sheet1 has 15 rows, I need to copy the formula in A1:G1 of sheet2 till
Hope someone help me
Thanks in advance
Message posted from http://www.ExcelForum.com/
You could add an unused row with a number or letter in it and then count
that separately each time with countif?
"SMILE...Cross referencing named row with named column
I'm trying to find a way to cross reference a column named June with a row
named Sales but cant figure out what the syntax is. I thought it used to be
=June|Sales but it doesnt seem to work.
"davide212" <firstname.lastname@example.org> schrieb im
> I'm trying to find a way to cross reference a column named June with
> named Sales but cant figure out ...Add Spell Icon to tool bar.
I cannot find the Spell Checker Icon in any of my pull down menus or add
buttons list. Where is it and how do I instal it on my tool bars in Outlook?
It is only available using Word as the editor in Outlook.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Tazz asked:
| I cannot find the Spell Checker Icon in any of my pull down menus or
| add buttons list. Where is it and how do I instal it on my tool bars
| in Outlook?
...Scroll Bar maximum value
I'm designing an interactive chart using a scroll bar object from the Forms
Toolbar. The data for my chart gets updated daily and I'd like to have the
Maximum Value of the scroll bar reflect the maximum number of data points.
Is there a way to do this? The Maximum Value entry does not seem to accept a
cell value or formula. I appreciate any help you can offer to solve this
The Maximum property can not be linked to a cell but you could use a
cell to store the value and update the scroller if that value changes.
Private Sub Worksheet_Change(ByVal Target...removing empty cells in a rows of data
Operating System: Mac OS X 10.5 (Leopard)
I have may rows of data and I want to remove the empty cells. eg <br>
A B C D E F G H <br>
1 X X X X <br>
2 Y Y Y Y <br>
3 Z Z Z Z <br><br>I want it to look like this without having to copy/cut and paste. <br>
A B C D <br>
1 X X X X <br>
2 Y Y Y Y <br>
3 Z Z Z Z <br><br>Is there any automated way to achieve this? Thanks Allan
..."Display Map of Address" not working...
Hi - noticed this on two machines, one XP and the other WIN2K, both running
Outlook 2003. When I click on "Display Map of Address" for a contact, a
browser window opens, but it cannot connect to the web site it uses, which i
believe is expedia maps; so the page is just empty. I've used this feature a
lot in the past without problems, and have never had mappoint installed on
either machine. I also found this problem when trying two separate browsers
as the default. Given that i'm seeing the issue on two separate machines,
thinking it's some sort of more global issue...Delivery Status Notification (Failure)
EX 5.5 sp4 nt4 sp6 i have a client receiving multiple
Delivery Status Notification (Failure) messages from
multiple domains. what could be causing this and how can
i make it stop.
forgot to mention the most important part she didn't send
the emails in the first place it appears to be SPAM
>EX 5.5 sp4 nt4 sp6 i have a client receiving multiple
>Delivery Status Notification (Failure) messages from
>multiple domains. what could be causing this and how
>i make it stop.
I think you just answe...