I'm trying to use the 'Money Browser' w/in MSN Money 2004
and get "Page Cannot Be Displayed" or sometimes "Action
Cancelled", but I can surf the web just fine with my
cable modem...what's up with that? I've read on this
forum that other users are having difficulties w/ this
particular issue, any resolution would be helpful. I've
regsvr32 msxml3.dll in start|run
also have un-installed and re-installed
...Restore ability to enter 20 character PO Numbers
With the 1.3R release, RMS will not allow PO Numbers longer than 14
characters. Before the 1.3R release, RMS allowed PO Numbers up to 20
After installing the 1.3R release I reported this defect. The support team
responded that this change was by design. They claimed that the change was
made to work around a defect - "we had a bug with inter-store inventory
transfers erroring out when the PO number is greater than 14 characters".
This type of quick and easy fix (crippling the UI to work around a defect)
is just plain wrong for at least a couple of reasons.
1) C...Customising page numbers
In MS Word, we can introduce the page numbers in header/footer and
customize the starting page number from 2 or 3 ... instead of 1. I
want to start the page number from 5 in Excel. Kindly help.
goto 'File - Pagesetup'. In the first tab is a textbox to enter your
starting page (think this was introduced with Excel 2000)
> In MS Word, we can introduce the page numbers in header/footer and
> customize the starting page number from 2 or 3 ... instead of 1. I
> want to start the page number fro...How do i get outlook to update hotmail account without reopening?
the tedster <the email@example.com> wrote:
Ask your question in the body of the message.
Without reopening what? Outlook? Hotmail? The short answer is "you
...Formula help... #3
In column A there are cells with team names in them like the following:
I would like column B to list all the team names without the @ symbol and
column H to list all the teams with the @ symbol. For the example I would
like column B to have
(remove nothere from the email address if mailing direct)
"Jambruins" <Jambruins@discussions.microsoft.com> wrote in message
news:135965C4-7523-47AB-88DE-D0B12B652CD5@m...Countif formula between numbers
I'm have a bad day and can't figure this simple question out. I want Excel to
count a column of numbers and show the the total cells with values between
100 and 125.
The formula I have thus far is '=countif(H5:H125,">=125<=100")
why is this not working???
This has been asked about a dozen times today. Homework assingment?
=sumproduct((rngA>100)*(rngA<200)). modify to suit
"dandigger" <firstname.lastname@example.org> wrote in message
news:1D44A5E6-ECAB-441D-B9D8-409D23D0369E@microsof...Analytical Accounting #6
I am trying to find a way to do more detailed reporting from the General
Ledger. Your GL is only as strong as the number of segments and the number of
ways you can slice and dice the data based on the combination of segments. We
have over 40,000 accounts in our GL and that is not enough.
I have not read through the PDF on Analytical Accounting yet. Could somebody
briefly explain what Analytical Accounting does.
Nutshell version: you can create codes (and groupings of codes), and assign
them to account numbers. For example, you could have one account that tracks
all Grant Money receive...outlook 2000 help file
Seems after I did added SP3 from MS upgrade site my help from outlook has
quit working. message is msohelp caused error in itss.dll. help works in ALL
other programs including outlook address book. I'm running windows 98 SE,
Office 2000 SB and IE 6.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.542 / Virus Database: 336 - Release Date: 11/18/03
...allowing or disallowing changing the state of check box
what's the best moment to check if the user has right to change the state of
check box and then to allow it or cancel it. I've tried with "before update"
event procedure. It seems to work but after, when I press anything else on
the form event procedure is repeating?
The problem occurs (repeating) when Cancel = True was applied previosly.
> what's the best moment to check if the user has right to change the state of
> check box and then to allow it or cancel it. I'...MSN accounts dosen't work in Outlook.
I can't download my e-mails from MSN to Microsoft Outlook 2003.
I have setup the account correspondent to Microsoft Outlook 2003 Wizard, but
it still dosen't work.
Does anyone know where the problem can be?
Only the paid MSN and Hotmail accounts will work in Outlook and/or Outlook
Express. Are you supscribed to the paid service?
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"hardharut" <email@example.com> wrote in me...Excel Edit F2 button changed for Mac???
Switched to Microsofts version of Excel for Mac. Can anyone tell me
what keystroke allows me to edit a cell? Before I switched to a Mac
it was the F2 button. Please help. Thank you.
See the answers in the m.p.mac.office.excel newsgroup.
In article <firstname.lastname@example.org>,
> Switched to Microsofts version of Excel for Mac. Can anyone tell me
> what keystroke allows me to edit a cell? Before I switched to a Mac
> it was the F2 button. Please help. Thank you.
...Changing Posting Settings
I just wanted to double check that if I am currently Posting TO General
Ledger in the Purchasing Series, if I change that to Post THROUGH General
Ledger will this have any ill effects.
I would make sure everyone is off the system, however if there are batches
in the GL that were generated by the AP subledger is this ok and would it
then post through the general ledger for any new transactions posted once I
change this option?
You are fine. Manual post any GL batches. You can do this before or after you
change the option.
> I just wanted to double che...Money 2005 Startup processing
Can anyone tell me what Money 2005 is doing the first minute or two after
loading. It's sucking up lots of cpu cycles and is very unresponsive. I
thought it was downloading stock updates etc. but my portfolio appears to
have the latest information while all this processing is going on. Money
2003 did not seem to do this. Is there any setting that I can change to
discourage this user unfriendly behavior?
...how to divide a numbers in a table of data by 1,000, all at once
I've noticed in some spreadsheets that numbers are displayed as
rounded...i.e. so that one isn't looking at 1,403,333 + 2,333,999 etc. but
rather 1403 + 2334, etc. with a note at the top that says "000's".
In one step, how can I edit all the numbers in a table so that they show to
the nearest 10,000 (i.e. 1403 +2334), without dividing them one by one by
Or, to go at it from another angle, how do I divide each # by 1,000?
The ROUND feature requires that I create a new table. Not exactly what I'm
Enter 1000 in an unused cell.
...Money 2002 Can't seem to download sucessfully
I have been trying for 10 days now to download banking
info from my various accounts into Money 2002. Before it
worked, now for some reason it is showing that it is
downloading, but doesn't import into the Money program.
What happened? I created a Passport to work online, but
that is the only thing that has changed on my end. Can
someone please help me!!?!?!?!??!
>I have been trying for 10 days now to download banking
>info from my various accounts into Money 2002. Before it
>worked, now for some reason it is showing that it is
I keep getting this
Problem Event Name: BlueScreen
OS Version: 6.1.7600.2.0.0.256.48
Locale ID: 1033
Additional information about the problem:
OS Version: 6_1_7600
Service Pack: 0_0
Files that help describe the problem:
Read our privacy statement online:
If the online privacy statement is not available, please read our
p...Globally change part of a field
I have a text field that holds the file location of a picture. The content
looks like this:
H:\Access Data\Personnel Pictures\picturefile.bmp
The "picturefile.bmp" is different for every record. Everything preceding
it is identical in all records.
I've moved the folder with all the pictures to a new location and need to
update this field to the following:
S:\Everyone\Member Database\Personnel Pictures\picturefile.bmp
So basically, I need to swap out "H:\Access Data" for "S:\Everyone\Member
Database" in every record.
Thanks in advance.
Jer...How to download into investment account?
Trying to download from the Charles Schwab & Co into my
investment account. Just recently converted from Quicken
to Money 2004 and then i am having issues with
downloading from Charles Schwab. When i download from the
FI i get transactions dating back to August which is
there in the register already. Now when i make that void
i cannot delete this and this is not going from
the 'Review transactions' list after i download. Now
tried to setup online services with a new file and when
downloading have new issuew. The date range is for the
past month but the cash account is gr...Unable to create more Windows NT accounts for Exchange mailboxes
Currently our Exchange server stopped allowing the creation of more Windows
NT Accounts with the following error"Insufficient System Resources exist to
complete the requested service".Pls is there a way out of this?
We run Exchange 5.5 SP3 on Windows NT Server.
...Synching with MSN Money
What's going on with synchronizing with MSN Money over
the last couple of days. I can't be the only one
experiencing the unexpected error has occurred problem. I
use 2004. Anyone else out there seeing it?
Don't feel bad. I have the same problem trying to synchronize. I don't like
the idea of synchronizing and never have in the past. But the upgrade to the
new portfolio manager on MSN overwrote a very old file and my portfolio is
way out of date. I recently built a new system and loaded Money 2004 clean.
Restored and converted a 2003 file, then tried to set up synchronizati...Change password
I have a work book that basically holds appointments. When all the
appointment slots are full I lock the sheet so changes can't be made without
approval first. How can I change the password?
Nevermind I figured it out. Thanks.
"Anthony G of La Quinta" wrote:
> I have a work book that basically holds appointments. When all the
> appointment slots are full I lock the sheet so changes can't be made without
> approval first. How can I change the password?
...Macro Help #11
Need help with a Macro. I have a work book with multiple sheets. I need to
make a master sheet from all the others, that will combine all the data. The
first column of all the sheets contains the product model number and how all
will be organized. Also if possible, when master sheet is made, can the
information be assorted ascending and also if duplicate data can be removed.
Thanks for any help,
...Birthday / Anniversary Help
Wonder if someone here can answer this question!
In previous versions of Outlook I'm sure I've seen a feature where if you
store a birthday in the calendar, the birthday automatically increments
year-on-year, providing a helpful reminder of how old that person is...only
I can't find this feature in Outlook / Office 2003....
How / where do I find this feature?
There's nothing built into Outlook that will do this...perhaps you had an
add-in or a macro that would do it? Where did the incremented age value
MVP - Outlook
*** M...Investment Account Download
My wife and I both have Retirement Accounts with The Vanguard Group. Whether
or not I open her file in Money 2006, when I download HER Statement it
automatically goes to MY Account. I've tried everything I know...Downloading
with her account open in Money, closed in money, and no matter what I do
Money automatically thinks it's my Account. Any help available?
In microsoft.public.money, Jerry <email@example.com(donotspam)>
>My wife and I both have Retirement Accounts with The Vanguard Group. Whether
>or not I open her file in Money 2006, wh...Sorting some information help
I have a sheet with 25 columns and up to 10000 rows. The number of rows
will always be the same for each worksheet. and contain text information
only. What I would like is a macro to show in 2 rows below the last row
for each column, how many times the text that appears in row 1 occurs in
row 2 thru (the last row) above it.
Thanks in advance
Enter the following formula in cell A10002, and copy across to column Y:
> I have a sheet with 25 columns and up to 10000 rows. The number of rows
> will always be the same for each work...