Asks to insert Disk 2
Had Office 2000. Upgraded to XP. Can't open Publisher
without inserting Disk 2 of 2000. Deleted, reinstalled,
downloaded all updates and patches. Still won't open
Publisher without inserting Disk 2.
PUB2000 Error Message: The Feature You Are Trying to Use Is Not Available
Mary Sauer MS MVP
"Glen" <GFGriffin@msn.com> wrote in message
> Had Office 2000. Upgraded to XP. Can't open Pu...Money auto-assign category to downloaded transactions
It's happened several times, but I can't quite pinpoint the trigger to
it. Every now and then, when I download transactions into Money, it
random assigns a category to all the transactions, and the category is
the same one. For example, just earlier today, every transactions
downloaded was assigned "automobile" as the category. I have tried
different options under Tools - Setting - Online Sevices Setting, but
I can't quite figure out how to prevent this from happening. Any idea?
In microsoft.public.money, namsilat wrote:
>It's happened several times, but I can...Installing Money 2005 Deluxe #2
Can anyone tell me if I can install one copy of Money on my desktop and laptop?
Microsoft seems to be keeping it a secret unless I pay $35.00 to ask a
In microsoft.public.money, Anthony wrote:
>Can anyone tell me if I can install one copy of Money on my desktop and laptop?
>Microsoft seems to be keeping it a secret unless I pay $35.00 to ask a
Yes. That is permitted.
Thank you, Cal. I've been all over Microsoft's Web site and couldn't find
anything on that.
I will purchase MS Money 2k5.
By the way, I have been using the trial vers...Auto Refresh on Opening
Created an Excel spreadsheet that runs an Access database
query and loads the results into a cell.
Problem - I want the data automatically refreshed (from
Access)when I activate the spreadsheet in Excel. How/Where
do I "code" for Excel to "refresh" before showing me the
first worksheet. (Don't want to see a prompt - just want
to get the latest data without having to click data
> Created an Excel spreadsheet that runs an Access database
> query and loads the results into a cell.
> Problem - I want the data automatica...Suppressing auto format in Excel
I have a .CSV file that is automatically generated by a program.
Apparently, when the file is opened with Excel, the numeric fields that are
enclosed in double quotes in the file and look like "123,456.1234" are being
formatted by Excel and displayed with only 2 decimals. The cause of the problem
seems to be the comma in the number, which I don't really want to remove.
Is there any way to suppress automatic cell formatting in Excel, so the
contents could be displayed just the way it appears in the source file?
In the Text import wizard - step 3 of 3 - select the offending colu...MO reports serial number has already been created
I have a user who does Inventory transfers for serialized items. When a
serial number he is looking for is not in the site it should be, he looks for
it in some other ites. Once he's exhausted his search, he creates an MO for
the item. When he's creating the MO, he tries to enter a serial number but
GP reports that the serial number has already been used for this item. We can
not find any instance where the serial number has been created.
Has anyone seen this before? Any suggestions?
...Set the serial number every 15th column
I would like to set the serial number every 15th column.
A B C ..................
Is there any formula for A column?
Thanks in advance
In A1 and then copy down
Copy Col A and paste special as values.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
It'...Convert number to text and add comma separator for thousands
I have a Text Box in a User Form that I am creating. The Text Box's
value is set to a number without decimals.
Dim rents As Long
rents = 4102
rentsTxtBox.Value = rents
So when the number passes to the Text Box, I want it to display like
this: 4,102. Basically, is there an vba function for excel that
converts a number to a string and then adds the comma separator for
thousands? If not what code would I use to do this?
rentsTxtBox.Value = Format(rents,"#,##0")
(change the xxxx to gmail if mailing direct)
"prahz" <ptho...Information Store won't start after installing exchange (in child domain) #2
We are installing exchange 2003 in a child domain of a domain tree where an
exchange 2003 server already exists in the parent domain.
Netdiag and DCDiag were both performed before installation and indicated no
problems with the general setup.
The account used to install exchange has Full Exchange Administration rights
at the org. level.
The installation completes without any error messages, but it is impossible
to start the information store.
The store refuses to start and events 9153, 1121 and 5000 are then logged in
Event 1121: Error 0x8004010f connecting to the Microsoft Ac...How do I make 11.800 convert to 800 as a number not text
I want to drop the 11. and have the cell next to it be 800. I want to
then be able to use that 800 and add other numbers to it. I am having
two problems, 1) the 11.800 always becomes 11.8 ( I have tried
increasing the decimals) and 2) if I have a different number like for
example 11.255 by using RIGHT I succeed in getting 255 but as text.
Thank you all in advance
Message posted from http://www.ExcelForum.com/
=MOD(A2, 1) * 1000 will give you the 800 from 11.8
mvpearl omitthisword at verizon period net
-----------------------------------------...Offline Address Book not updating #2
Our clients who used cached mode aren't getting an updated offline address
book. We tried a rebuild but that didn't work- any suggestions.
We are running Exchange 2003 SP2 on a Windows 2003 server.
"Boe" <email@example.com> wrote:
>Our clients who used cached mode aren't getting an updated offline address
>book. We tried a rebuild but that didn't work- any suggestions.
>We are running Exchange 2003 SP2 on a Windows 2003 server.
Check the Applications Log on the OAB server and make sure the OAB is
being generated. There w...Excel to XML #2
'Is there a converter for Microsoft Excel 2000 files that
will save the files as .xml'.
File, Save As
the file extension is still .htm or .html
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"MS" <firstname.lastname@example.org> wrote in message news:email@example.com...
> 'Is there a converter for Microsoft Excel 2000 files that
> will save the files as .xml'.
...Data file did not close properly #2
I have read all kinds of solutions to this error. Has any thing difinitive
been offered that solves the problem. Appreciated
There isnt a difinative solution as the problem can be caused by a number of
"Jerry" <firstname.lastname@example.org> wrote in message
>I have read all kinds of solutions to this error. Has any thing difinitive
>been offered that solves the problem. Appreciated
"Jerry" <email@example.com> wrote in message
news:eRfw6Cs1IHA.5300@TK2MSFTNGP06.phx.gbl...Auto notification about inactive account
Is there a way to notify an external sender that the email address they are trying to reach has been removed? We have already deleted the account and the default email goes to our administrators mailbox. Do I need to recreate the account and set some options up to automatically notify those senders
Any help is greatly appreciated
Thanks in advance
P.S. - Sorry if this shows up more than once. I posted it earlier, but didn't see it in the new postings for some reason.
John C <firstname.lastname@example.org> wrote:
>Is there a way to notify an external sender tha...Mutual Fund Merger #2
I read the posting from Oct 03 and followed the
I completed the ratio as instructed. Problem is now I
cannot change the investment name or symbol to that of
the gaining fund because it is "already being used" by
Help please. I have Money 2004 Small Business.
Oct 03 posting info is below
I have Money 2002 Deluxe & Bus.
>>>I recently had 2 mutual funds merge and I cannot
>>>out how to handle this in the Money program. It tells
>>>about Company mergers and I read about 3 different
>...CRM Rollup 2 for Windows XP x64 client
Have been running CRM 3.0 on a Windows XP SP2 x64 client for a while without
a problem, have to perform a repair in the install the other day and needed
to apply the rollup 2 for the install, however when I attempt to perform the
install it tells me it's for another hardware platform. Is there a version
for x64 Windows XP I missed?
Any help would be appreciated.
...Excel drop down lists #2
I am trying to create two drop down lists.
The first is a straight forward selection of 6 choices.
I would like to be able to have a list in the next column which is dependent on the choice from the first list.
For example from a choice of "A, B, C, D" in the first list, if i choose "A" I would like to have a drop down list choice of "9, 8, 7" in the second column. But if i choose "C" in the first list, then I would like to have a drop down list choice of "6, 5, 4" in the second column.
Is this possible? And if so, could you please tel...Auto Accept Agent Double Booking Support
Is it possible to configure the Auto Accept Agent to support double booking?
We have some resources that need to allow that.
...Number of Observations
I have a column (say Column A) with 300 values (basically it is a DDE link
with data I update).
I also have a cell I would like to use (say B1). In cell B1 I would like to
be able to enter a value (say 20) where I will be able to use this value in
another cell to "observe" the top 20 of the cell from column A. So, If I put
20 in cell B1, in cell (say C1) I would like to put some formula where it can
reference the "how many observation" cell B1, and say sum A1:AXX where xx is
the value in cell B1.
I know in this form it cannot be done, but was wondering if someone ...Preventing auto-formatting when Replacing
Say I have a cell that contains
The cell is formatted as Text.
If I use Ctrl-H to replace LED with nothing, Excel insists on reformatting
the remaining 2/14 as a date (i.e. 14-Feb). Is there any way to prevent this
Frank Marousek wrote:
> Say I have a cell that contains
> The cell is formatted as Text.
> If I use Ctrl-H to replace LED with nothing, Excel insists on reformatting
> the remaining 2/14 as a date (i.e. 14-Feb). Is there any way to...Multiple Taxes (i.e. 2 Diff States)
I am trying to establish two different Item tax structures for two different
tax authorities, let's say one for MN and one for ND state.
Preface: I am giving this as a real HL example. Assigning taxes on a per
customer basis will not work as a solution to this issue. Please do not take
it literally that I need to assign per customer based on Billing or Shipping
MN Tax has: MN State, MN City and MN County
ND Tax has: ND State and ND County
I have created all tax authorities in Sales Tax, and then bundled
appropriately in Item Tax (one item tax = MN St...How can you identify folders, using folder numbers?
I've searched and searched and asked in the quasi-defunct yahoo
exchange newsgroup, but I've never found an answer as to how I can
actually utilize the folder identification information contained in
Exchange error log events.
An example is as such:
Source: MSExchangeIS Mailbox Store
Description: Error 0x6bb deleting unused restricted view from folder
1-1A42FF on database "First Storage Group\SG1 Mailbox1".
It would be insanely useful if I could tell which folder 1-1A42FF is,
so I can narrow down where the problem is occurring, you know??
Anyone...Sort combination of letters and numbers
I have this type of data to sort: C-1, C-2, C-3, C-4, C-5, C-6, all the way
up to C-500, but it doesn't sort into number order. How can I make it sort
by number, and disregard the "C-" part? thanks!
Assuming your data is in column C and it starts in row 1...
In a blank column next to your data enter this formula...
Fill the formula down to the bottom of your data.
Select both columns and sort using the new column as the key.
Portland, Oregon USA
(Excel Add-ins - try the "Special So...SVG problems in Visio 2003 SP 2
I tried to create a new document (metrics format) and added a few
different shapes (also metric). I saved the document in SVG format and
closed the document.
I then tried to open the document again, but got a lot of errors, and
some of my shapes could be located at the lower left corner, but a bit
misshaped. Also when opening the document i IE it is incorrect. (I
detected this behavior with a mush more complex drawing, and that was
totally messed up after saved as SVG.)
Is this a known error, or is there something wrong with my local setup?
Op...outlook contacts #2
When I try to access my contacts in outlook 2000, via the
toolbar or menu it immediately shuts down outlook.
Could anybody clear up what I have done to cause this.
I tried re-installing it and running the repair to no
This is very annoying.
find and rename outcmd.dat and restart outlook. Does it fix it?
"Dan" <email@example.com> wrote in message
> When I try to access my contacts in outlook 2000, via the
> toolbar or menu it immediately shuts down outlook.
> Could anybody clear up what I hav...