analytical accounting lookups should only show valid codes
When entering AA transaction distributions, the code lookup window should
only show valid code combinations. It's not intuitive for the user to have
to select a code and get an error message to discover which codes are valid.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the mess...Outlook shows offline during dial up
Having a problem with outlook 2002. Over the WAN
everything works fine. Dial up and connect to the
network (VPN) internet work fine. Outlook will sync up
however, a red x shows up in the bottom right hand
corner. Outlook shows offline, I can send and receive
but must hit send and receive. I have reloaded the
computer from scratch and still have the same problem.
Could it be a Excange setting? Any Ideas?
Thanks for the help,
If you hit File | Connect to Exchange Server what happens?
Ben M. Schorr, OneNote-MVP
**I apologize ...Excel no more new fonts
I'm getting the message "no more new fonts may be applied
to this workbook". How can I get around this?
Any chance that you have a lot of charts in the workbook?
There's a limit of 256 fonts in a workbook and each chart uses
up two of them.
Check here for more info.
"Tuan Ma" <firstname.lastname@example.org> wrote in message
> I'm getting the message "no more new fonts may be applied
> to this workbook". How can...reminder still shows up
when I run Outlook.exe /cleanreminders it simply opens Outlook, I am running
"Toppro" <Toppro@discussions.microsoft.com> wrote in message
> when I run Outlook.exe /cleanreminders it simply opens Outlook, I am
Outlook version? The Windows version isn't as important and that of Outlook.
Brian Tillman [MVP-Outlook]
I want to know why there are
blank lines after the 1300 lines I imported? I want the spreadsheet to just
cut off at , lets say, 1310 lines. How would that be accomplished?
I would also like the just have cells A thru H and no cells to the right of
that. How can that be done?
you can't delete these rows/columns. What you could do is hide them
(Format - Rows/Columns - Hide)
> I want to know why there are
> blank lines after the 1300 lines I imported? I want the spreadsheet
> to just cut off at , lets say, 1310 lines. Ho...Drag-and-drop hyperlink
What I want to do is simply drag-and-drop a link from IE to Excel and
have it insert the URL of that link. This works fine in MS Word. Am
I missing something simple? Is there a way to do this in Excel?
Thanks for your help!
...Excel tie custom toolbars and macros to Emailed worksheets
I have made a worksheet for a work rota this includes a custum toolbar with
Macros to enable rapid completion of new rotas. when i eMail the worksheet to
other users the custum toolbar is not included or does not work
You could attach the toolbar to that workbook.
If you're going to do that, you'll want to read Jan Karel Pieterse's notes:
Another option would be to build the toolbar on the fly (when the workbook is
opened) and delete it when you close the workbook.
Here's a shell that I use to b...Show a blank result in a cell when there is no value in the "Lookup" cell
I apologize if this question has been asked, but I have been unable to find
an answer searching the topics.
I'm using the following formula in cell C3:
When I type in an employee ID in A3, his/her last name shows in C3.
However, when there is no value in A3, C3 shows error "#N/A".
Is there a way to show a blank cell in C3 until a value is entered into A3?
Thanks in advance!
On Aug 5, 10:45 am, "Michael Slater" <mslater...@comcast.net> wrote:
> I'm using the following formula in cell C3:
> =INDEX(LastNam...Show Window
I am currently developing a MFC SDI application. I want to integrate a
tray icon with it. When the application is minimized it hides by
ShowWindow(SW_HIDE) and then when double clicked on tray icon shown by
But the problem is if some other application is activated after my
application is minimized, ShowWindow shows it but it's behind some
screen. I have tried with SetFocus didn't work.
Please help me to solve this problem.
In addition to Ajay's idea you can also use SetFor...Information Stores show dismounted yet mail is still flowing...
Windows AD Mixed moded. Exchange 2003 installed on to a 2 node Microsoft
cluster. 1 Front End server...connecting to the primary cluster node.
Windows 2003 Standard on, FE Windows 2003 Enterprise Server on BEs
(<---cluster) no service packs on either. Exchange has SP1 installed on both
nodes and the FE. There are still Exchange 5.5 servers in the environment
although they are not being used.
.....the information stores and public folders all show that they are
dismounted...yet email is still flowing into and out of the server without
any issues. I just...How do I convert cab file to open an Family Budget Excel Template?
The file dowloads as a .cab file. When I try and open it, it's not in a
format. How can I download the correct format.
Hardly an excel question
From where do you download an excel template as a cab file?
Try winzip, I believe they have an option to open some cab files
> The file dowloads as a .cab file. When I try and open it, it's not in a
> format. How can I download the correct format.
...Using ajax call to fetch multiple results from multiple queries and showing them 1 by 1 as the results comes.
I've 20 labels in a 2x10 table on a page. for each label, data comes by
individual queries. (total 20 queries for the page.) and it takes about
30-40 seconds for the page to load, and it's not comfortable for the user to
see blank page. I want that each cell will show loading.gif images. As and
when data comes from query, the images should go visible=false, and the
label should display the values one by one. How do I do this task using
Some ASP.NET code example will be helpful for me, as I'm a kind of beginner.
...Why Excel outlines cells that change?
Lately, Excel seems to outline cells that I change.
The outline seems to remain until I cause the window
to be update -- for example, scrolling the cells out
of view, then into view, or minimizing, then maximizing
If this is an option that I can disable, please tell
FYI, I am using Excel 2002 (10.4302.4219) SP-2.
Unfortunately, I am using an MS Win server that someone
else controls. So I do not know what changed to cause
this new outline behavior.
goto 'Tools - Track changes' and disbale this feature
Help Me wrot...Results show as a minus. WHY?
I have an application that was developed by another developer using VB.net
which reside in a SQL table. I need to use some of the data from this table,
however the data shows as -0.5 or - 0.99 or -1.70 etc in my Access tables.
How can I get those numbers to show as a percentage with only one decimal
point to the left? Example: 3.6% or 31.4 %. Any help would be greatly
appreciated. No matter what I do it shows that dang "-" at the beginning.
You can use the Abs function to strip off the negative
And you can format that as percentage either using th...Importing information into Excel
Can you create a form that has fields that can be exported into Excel? or
even an Access database? I created a form in Word, saved it as a txt file
and then imported it into Excel, but that didn't work. It seemed to work in
Office 2003 but not 2007.
How did you "import" and what is "didn't work"?
You open a *.txt file in Excel you should get the Text Import Wizard popping
up so's you can parse the text.
Works for me in 2007
Gord Dibben MS Excel MVP
On Mon, 25 Jan 2010 16:33:01 -0800, confused in PDX <confused in
PDX@discussions.m...Datetime drop down
I have created a form with a datetime drop down. Currently there are
two fields displayed - one with the date in and the second with the
time in half-hour increments.
The question is: is it possible to change the time drop down so it
shows the time in 15 minute increments?
...Arrow keys move work sheet and not from cell to cell???
I apparently have inadvertantly checked something so that when I use my
arrow keys I do not move to the next cell. Rather the work sheet itself
moves. I would deeply appreciate any help here. Thank you in advance for any
Touch Scroll Lock
Gary''s Student - gsnu200847
> I apparently have inadvertantly checked something so that when I use my
> arrow keys I do not move to the next cell. Rather the work sheet itself
> moves. I would deeply appreciate any help here. Thank you in advance for any
>...how to show numbers that begin with 0 in excel
I need to type numbers into an excel spreadsheet some of them begin with a
zero some do not. How can I have excel show the 0 in the numbers that begin
with 0. If I type 0236547 the number shows as 236547. I don't want all the
numbers I type to begin with zero.
I am using Excel 2003. Thanks very much for your help.
use a custom format with how ever many digits you need, 000000
"Dee" <Dee@discussions.microsoft.com> wrote in message
>...Comments not showing
When a SharePoint workflow is edited and a comment is added. The comment does
not display in the workflow status screen under workflow history.
It shows as follows: Task assigned to Andre Wessels was completed by System
Instead of: Task assigned to Andre Wessels was completed by System Account.
Comments: Please update to the new company logo.
This happens for all standard SharePoint workflows (Approval, Collect
Feedback). Any custom workflows does show the comment. The comment field is
update in the task item. It just does not show.
There is no error in t...Report Server shows 'Service Unavailable'
before install, the SRS setup, send me a warning, some like "the Windows
Sharepoint Services are install and not permit initialize a Reportserver
i skip wiht the installation, so..
I can't run
http://<localhost>/Reports and http://<localhost>ReportServer
show a message "Service Unavailabe", but the ReportServer service is running
How initialize that or what do i do?
> before install, the SRS set...EXCEL ROW DELETIONS
I have a workbook with 10,000 rows of zipcodes, every
other row is blank. I need to delete these blank rows. Is
there a way it can be done all at once instead of
selecting each one?
You could sort and delete all at once.
"Laine" <email@example.com> wrote in message
> I have a workbook with 10,000 rows of zipcodes, every
> other row is blank. I need to delete these blank rows. Is
> there a way it can be done all at once instead of
> selecting each one?
"Laine" <elipari@da...show comments when cell is highlighted Vs when cursor runs over? #2
How do you make the comments appear when the cell is highlighted opposed to
when the mouse cursor runs over the cell?
You can press Shift/F2, or Insert/Edit Comment. If you wanted to see it
"automatically", when you select the cell, you'd need a macro, but I don't
think this is what you're asking.
> How do you make the comments appear when the cell is highlighted opposed to
> when the mouse cursor runs over the cell?
To at least Excel 2000, if you have the Tools, Options, Comment Indicator Only
you will see the co...Show more time in weekly view?
On default the weekly view is only showing until 4 PM without scrolling
down. I know there is a way to let you see into the evening hours also
I would like to find a formula in excel that will countdown years, months,
days, hours, minutes and seconds from one point in time to another. Datedif
works for years, months and days, but I can't find a function that
calculates hours, minutes and seconds. Does such a thing exist?
Thank you for your time,
This formula counts down from now until Christmas, refresh by pressing F9
=IF(TODAY()>DATE(YEAR(TODAY()),12,24),"Wait Until After New
"&DATEDIF(NOW(),DATE(Y...Drop Down Menu
Probably a silly question , but is it possible to have images displayed in a
drop down menu in excel as well as text?