My really be a "data" issues not a vlookup issue - but here is the problem;
1st column of my table_array:
These will NOT sort in proper order.
Does not matter if the cell is formatted text.
Does not matter if the cell is formatted Number
Does not matter if I clear all the data and type them in proper order by
why won't my data sort properly?
Any help here will be appreciated.
Thanks in advance
Formatting text to numbers won't change anything, you need to force
th...outlook 2007 issue
I am used to having my newest emails at the bottom of the screen and
the scroll bar defaulting to the bottom as well. I cannot seem to do that
in Outlook 2007/
try changing the sort order - click on the field called Newest on Top to
switch to Oldest on Top
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
Outlook Tips: http://www.outlook-tips.net/
Outlook &am...wbs layout
hi. i've created a wbs chart in visio(2003) based on info in ms project (2003).
problem is that although they are ordered sequentially they are not charted
sequentially in visio. children belong to correct parents but numbering could
be 1.4 then 1.1 then 1.6 etc. is there anyway i can correct this issue ?
I've created a spread sheet that contains a very long list going across in
columns , dates going down in rows.
For easy data input, I've shaded every second column in yellow.
The problem is, if at some stage, I need to insert a new column, I end up
with either 2 clear columns or 2 yellow ones (depending where I insert it),
then have to spend ages rearranging all the columns to have alternate
Also if I need to paste or move the contents of a cell, it takes the shade
with it, which is fine if you're putting it in a cell with the same colour.
Am I making sense?
I...Access template issue
There is a template download [Issues] for Access 2003 on the microsoft
template site. It can be saved either as a form or a data access page. The
issue is that after clicking file then save, it dissapears and cannot be
found by searching files. I've downloaded a number of templates and have
never encountered this. Don't know if there is a flaw with the file or how I
have handled it. Hoping someone can attempt a download /save/ launch to
confirm that there is an issue.
...Another time calculation issue, thanks for any help!
I was hoping to do this without to much difficulty but not having much luck.
I got the round down to the nearest 15 minutes. NOW I would like to round
up to the nearest 15 minutes (ie. .25, .5, .75 ONLY), in fifteen minute
intervals. Here's some of what I've tried so far...
Round(1.2/0.6,0) answer: 2 would like 1.25
Int(1.9*8.0+0.6)/8.0 answer: 1.875 would like 2
-Int(-1.2)/60 answer 1.66 would like 1.25
I store the time in decimal format (I need that for another calculation
which works perfectly).
"I feel I have been denied critical...User permissions issue in the employee maintenance card
I created a 2 new users in our GP 9.0 SP2. In Advanced Security, I
copied an older user's security to my new users.
When either of these users opens the Employee maintenance card and
then uses the quick links drop down on the upper right of the card,
both "Benefits" and "Deductions" are grayed out.
Oddly enough, both users can get to these features via the Dynamics GP
menu Cards --> Payroll --> both options are available.
Can anyone offer me some advice as to where to look to enable these
Thank you for your time,
- Greg Crowe
Try the following:
1. G..."auto capitalize" first letter in notebook layout
Operating System: Mac OS X 10.5 (Leopard)
while typing notes most of the time the first word i type will always auto capitalize wether it be at beginning of paragraph, new bullet, new sentence, etc. you get the idea. i have recently ran into an issue where it will be "auto capitalizing" fine, then i will look up and mid way thru my notes it just stopped doing this... i did not stop typing or make any format changes. did not switch views, NOTHING... literally was typing several bullets and topics and randomly mid way thru it stop. this has happened a fe...Email issues
We have a email issue that is not going away.
We have a SBS 2003 machine and a server for TS.
However, emails are disappearing both sending and receiving.
Office sends email out - Receiver has not record out email.
Receiver sends email in - we show no record of receiving it.
It only happens to external clients. and completely random.
We get a process.exe error in the SBS 2003 logs. However, can't get rid of
The patch says I have a newer version of exchange. etc
"travis" <email@example.com> wrote in message
news:DDB0B0F3-52E...wordart layout issue
I've used Wordart in a header in Word. Then:
Format/Autoshape/Layout/Advanced/Text Wrapping/Through. Now, I'd like to
select and modify the Wordart but I can no longer select it. I've tried
Select Object, double-click, etc., can't select it. Any ideas how to select
Use the white select arrow on the drawing toolbar.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ...Phone Formatting issue
My Outlook 2003 no longer formats phone number with ( ) and - it just
stings all the number together.. Does anyone know the tricks to get it
formatting again ?
...XL producing bizarre page layouts
I've been working on a 12-page worksheet for several days with Excel
2003, running XP, SP1.
This morning, when I attempted to print it, the 12 pages printed out as
three pages, with the pages printijng landscape orientation, but in
tiny size down the left margin. I saw that Page Setup was set to "Fit
to: 1 to 1," but the "Adjust to:" setting above--while unchecked--was
set to 10%, so I tried to set it to 100%.
I also experience the page allowing only the page width, about 7.5
inches, though it is printing in landscape. In other words, a wide
column that previously had...Category Issue
I have a loan that I set up in Money 2004. I set up a
budget that takes in account what amount I spend to
service the loan each month. The category that the budget
function in Money uses is called "Loan: xyz." Okay, after
doing that I thought everything was fine and dandy.
However, here is the problem: I pay my loan using my
checking account. When an entry is made to pay my loan
the category that I'm using is "Transfer: Loan: xyz." The
problem is, how does the budget know that I have paid the
loan when my checking entry is using the "Trans...Newbie-layout
I've never used Publisher before and have created a postcard that has a
message/picture on the "front" of the card. Is there a template to create
the return address and to address on the back of the card where I am going to
put the stamp? Also, do I have to make a seperate card for the back and
after printing the front of the card, flip the paper over to print the
address lines/stamp area on the back?
Thanks in advance.
You need to setup a merge for the addresses. It is a separate publication. You will
not have to merge the return address, type it into a text box,...reading layout
Went from Wordperfect to Word this week, only thing I can't locate is the
postion reading on the bottom of my screen to tell me where exactly I'm at in
my document, been all over in tools and can't locate where to turn it on.
Assuming this is Word 2007, right-click the status bar; on the context menu,
you can choose exactly what you want displayed.
Microsoft Word MVP
"Angie" <Angie@discussions.microsoft.com> wrote in message
> Went from Wordperfect to Word...Small but annoying 2005 issue
I have my password/passport login saved so I don't have to put it in
everytime. Works great. However if I jump over to MoneyCentral and then
ask for a real-time quote, log-in to passport, the next time back to MsMoney
I have to re-type my login/password again.
Anybody else notice this?
I had the same problem. Was able to fix the issue by
changing the password on msn billpay and then going back
to Money to change the password. It is important that
you change the password from an account page.. on the
left column look to update online services and you will
see the option to ...Issue with sending an e-mail to schedule a meeting in the Outlook 2003 calendar
I am not sure if this is an Exchange 2003 issue or an Outlook 2003 issue.
I have an Exchange 2003 server in a 2003 AD domain and clients on Outlook
2003. We have an issue with sending an e-mail to one user to schedule a
meeting in the Outlook calendar. When you send a meeting invitation to Mark
it automatically gets put on his calendar without getting an e-mail to
accept, decline or set to tentative, and it will send an e-mail invitation
to Bill even though Bill isn't on the list of attendees.
Would there be settings wrong in Exchange or in Outlook?
Thanks for helping!
Gre...Could keyboard malfunction be a registry issue?
I've used a wonderful Keytronic keyboard for 10 years, using it with every
generation of computer I purchase.
Yesterday, the space bar quit working along with the delete keys and the 3,
6, and 9 on the numeric keypad. So, today, I purchased a brand new keytronic
keyboard to replace it but whoops, the same problem remains. I switched to
this piece of crap microsoft keyboard that does not appear to have any key
problems but when I switch back to either of the keytronic keyboards, the
same problems pop up.
I'm stumped. I deleted the keyboard driver and rebooted but that ...gift certificate layout like a dollar bill
Trying to find a gift certificate layout like a dollar bill that I can add a
URL to for handouts.
I've a moneylike clip on my web site. You could enlarge it to fit about any space. It
is a .zip .wmf file.
Mary Sauer MSFT MVP
"TheEagle" <TheEagle@discussions.microsoft.com> wrote in message
> Trying to find a gift certificate layout like a dollar bill that I can add a
> URL to for ha...Folder Redirection and roaming Profiles issue
I had set up some users with Roaming profiles via their profile tab in ADU&C.
I had used a Group Policy to Redirect their My Docs and Desktop to a folder
on the server and have one folder per user only accessible by that user.
That was a year or two ago. I was setting up a new user the same way as
above, but when I logged into a Pc as them and was about to set up their
email, I noticed in the Section of the All Programs list that is above
ACCESSORIES, it lists all users who have Folder Redirection and allows you to
go in and view thier Desktop and My Docs documents and o...2003 Layout => 2002 Layout
I have been using Outlook 2003 for a couple of weeks, one
small problem is the new layout, is it possible to make it
look like 2000/2002 layout 'cos I can't bear it?
You can move the new preview pane to the bottom. try view | reading pane |
Neo [MVP Outlook]
Due to the Swen virus, all e-mails sent to this account will be deleted
"Jon Cook" <firstname.lastname@example.org> wrote in message
> I have been using Outlook 2003 for a couple of weeks, one
> small problem is the new layou...GP10 known issues?
Anyone know where to get a list of known issue/bug on GP10?
Search this forum. Several people have posted issues. Most are, we think,
going to be addressed with the soon to be released SP1. Major amonst the
issues is the failure of V10 to upgrade Security.
Richard L. Whaley
Author / Consultant / MVP
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
> Anyone know where to get a list of known issue/bug on GP10?
No, actually, 10.0 does upgrade security. This...Front-end server and back-end server issue
I am planning to use front-end back-end exchange server in the company
network. We have several exchange servers in different geographic sites. For
example: We have 3 exchange servers in site A and another 3 in site B. If I
set one exchange server in site A to be front end server, will it cause
problem to the other 3 servers in site B? I suppose I can always use the
front end server in site A for the clients in site B. Is it correct?
Installing an exchange front-end server should not cause any problems for
other exchange servers and one front-end server should be able to service
I am testing back up and restoe.
I backed up IS and dismounted and deleted priv1.edb and priv1.stm from the
I tried to restore IS wih "last restore set" option on and it faild and
these are the errors
Event ID : 904
IS (2920) callback function call
ErrESECBRestoeGetDestination ended with erro 0xC7FE1F41 database in us.
EventID : 8003
End restore to 'test\microsoft information store\first storage group' failed
verify : off
EventID : 8019
And I looked at the mdbdata folder and there were priv1.edb and priv1.stm
but I could not mount the sto...Issue with copy/paste dates from filtered data
I have a spreadsheet with a lot of account numbers. I have autofiltered
to sum a specific account number. I copied and pasted all of the data
associated with this account number into another spreadsheet.
Everything pasted fine, but the dates changed. For example, the first
row of the original data is for 7/1/2004, but changes to 6/30/2000 in
the new spreadsheet. Does anyone know why this happens and how to fix
so that the dates are consistent between the 2 spreadsheets? Thanks!
deacs's Profile: http...