Big background page numbers/ Can't change format of a range
I received a spreadsheet used for printing out tables of data.
This spreadsheet contains two features which I would like to understand:
1) Each Excel range that is printed on a separate page contains a big page
number in the background of the speadsheet: "page1", "page2" etc. This page
number, however, is not printed. How is this achieved?
2) There is a gray are outside the actual data range - and I can't change
the formatting of that area. The spreadsheet is not protected.
You're in "Page Break Preview".
<Vie...Discard Bank Reconciliation
We are currently on GP version 8, SP2 and have picked up a problem in bank
management where we are unable to discard changes to the bank reconciliation
upon exit - (Save, Discard, Cancel options available). Although we select
Discard, the reconciliation still saves the changes. Cash Book Management
version is 8.00g12.
...Copying and pasting into a filtered list
Does anyone know how to copy and paste into a *actual filtered * lis
without. i.e only paste items over the filtered rows specified. It
annoying because when you try it pastes over the rows in between th
rows actually filtered.
Please explain in simple english.
grphillips's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1595
View this thread: http://www.excelforum.com/showthread.php?threadid=27450
I think I'd use a helper column that allows me to sort/group the ...etransfers from U.S. bank
Starting August 7th MS money stopped making transfers between accounts at US
Bank. US Bank states that there is nothing they can do because the transfer
request is not being sent by MS Money. My screen shows the envelope with blue
lighting opject telling me the transactions are pending. However the right
click option allowing me to cancel the transaction does not appear on the
menu. I am manually making the transfer.
...Is there a Template for an event planning checkoff list?
I plan events and want to have a checkoff list format. Do yo know of such a
template that is available in Office, word or excel?
Microsoft provides these planning templates . . .
> I plan events and want to have a checkoff list format. Do yo know of such a
> template that is available in Office, word or excel?
...Again Adding Names to Dist List
When I add names to a distribution list undr my contacts, they
only appear under the distribution list and don't appear under
Contacts? They use too until I've upgraded to Outllook 2003.
Any help would be appreciated.
I am not familiar with the functionality of adding names in Outloook to a distribution list, and at the same time, having the contact automatically added to the contacts folder. My experience is that you will
need to add each contact into the contacts folder seperately.
Scott Atkins MCSE, MCSA
Partner Technical Lead - Outlook
Microsoft Office 2000
I have two graphs on one chart and both axis are used. The left axis is
based on whole numbers. The right axis is based on percentages. I have
no problem adding a trendline to the line graph using the left axis. I
cannot add a trendline to the line graph using the right axis
(percentages). When I right click the line graph and select "Add
trendline" nothing shows up. However, the "undo" feature says "Undo add
trendline". Could Excel be trying to use the left axis as reference for
Also, for additional informat...AD issue with CRM 3.0 installation
I get the following error on the last page during installation: "Setup was
unable to verify that the "Trust for Delegation" property is enabled for the
I am a newbie and I would appreciate any help in this regard.
From what I remember this is only a warning, not an error, so you can
continue the installation.
There are several reasons for this warning that don't affect the CRM
installation; the most common is if you don't have Domain Admin rights
David Jennaway - Microsoft Dynamics CRM MVP
Web: http://www.excitation...Outlook Authentication Issues #2
Environment: Outlook 2003, Exchange 2003, Single Domain,
Periodically, I get a prompt to enter my login credentials when opening
outlook. I've been using this network for at least 2 years, and this
has never happened. Furthermore, this issue is not happening to
everyone. I believe I've received this complaint from one other person
about six months ago. Any ideas?
On Feb 6, 11:36=A0am, D|an-0 <D|a...@newsgroup.nospam> wrote:
> Environment: Outlook 2003, Exchange 2003, Single Domain,
> Periodically, I get a prompt to enter my login credentials when...Adding an account??
Just bought money 2005 Deluxe, I sign into my Passport,Money opens, I go to
online acct setup, everytime the online list is unavailable and I am unable
to setup my banking, investment, or any other acct. Whats up with this
In microsoft.public.money, ametty wrote:
>Just bought money 2005 Deluxe, I sign into my Passport,Money opens, I go to
>online acct setup, everytime the online list is unavailable and I am unable
>to setup my banking, investment, or any other acct. Whats up with this
...PM Remaining Balance Does not Tally with Applied Documents
On few occassions, the PM Remaing Balance does not equal to Document Amount
less Total Applied Amount.
eg: PM INV amt $100, paid by 2 payment of $60 and $40.
the 2 payment became HIST yet the INV remains OPEN and current trx amt is
what we normally do is to VOID the 2 payment, the INV current trx will then
become $200, then use SQL Analyzer to change to amount to $100, re-enter the
2 payment. These is kind of 'toublesome'...
does anyone has a script that will:
* list such trx where the remining balance <> applied amt
* in above example, to move the INV from OPEN...Searching Through Long List of Completed Activites
Is there any way to use a seach tool to search through completed activities
on the history tab? We have converted Activities in from Goldmine and I am
already on page 48 and still only now in the B's and you can guess how manu
records there might be. There is no Find availble on any menu. Any
Tools > Advanced Find and select Activities from the drop-down. Does this do
what you are looking for?
"Shauna Koppang" wrote:
> Is there any way to use a seach tool to search through completed activities
I do not see any credit card account for household bank
credit card. here is the link:
can anybody tell me whether this card is in money 2004?
In microsoft.public.money, nair wrote:
>I do not see any credit card account for household bank
>credit card. here is the link:
>can anybody tell me whether this card is in money 2004?
See if Household Credit Services works for your card.
...associated external account #3
I am running exh2k on a win2k domain. I have noticed that most of my enabled
users don’t have associated external account checked in their mailbox rights
permissions. Some of the users have it check for an object that is no longer
available. I have noticed when doing an exmerge I cant exmerge any disabled
users mailboxes unless they have associated external account checked for self
1.The most concerning issues is that we are about to upgrade to exch2k3.
will their be a problem if users mailboxes don’t have associated external
mail account checked for any of the permissions in th...Date/Time issue with Pivot Table
I have column of data that is both date and time. However when I create the
pivot table I only want it to summarize the date.
I've formatted both the source and the pivot table to display on the date
but formatting doesn't affect the underlying data so if a date has three
different times, then the pivot table has three different entries for a given
I can (and have) parsed out the serial number to remove the time portion but
that gets a bit time consuming and this comes up frequently in different
spreadsheets. I'm wondering if there's away to ...Account Payments not kicking Cash drawer
Does anyone have any suggestions here.
The cash drawer kicks fine for most transactions. However if you process an
account payment through POS the cash drawer doesn't kick and I can't seem to
find any settings that might be controlling this - any suggestions?
I am not sure if this will help.
Make sure you have a receipt format selected for the Payment.
Maybe there is no receipt to print for payment and the printer is not
opening the cash drawer.
"Emer" <Emer@discussions.microsoft.com> wrote in message ...Bank Reconciliation #3
What happens when the Bank reconciliation balances do NOT agree with the
General Ledger Balances?
How do we go about rectifying the Bank reconciliation to agree to the GL
Had entered Increase Adjustment in Cash Transaction that threw out both
these balances. Would appreciate your assistance.
Once you figure out where the problem is, you will probably need to do a
journal entry. I have never had that happen.
> What happens when the Bank reconciliation balances do NOT agree with the
> General Ledger Balances?
> How do we go about rectifying the Bank...M04: Account list balance does not match register balance
Everything was fine for months until about a week ago.
One of my credit card balances in the account list is much higher than the
balance shown in the register (register balance is correct). What should I
Consider File|Repair Money file|Quick file repair. Alternately, read
"Tod DeBie" <firstname.lastname@example.org> wrote in message
> Everything was fine for months until about a week ago.
> One of my credit card balances in the account list is much higher than the
> bala...Time Stamp Issues
Has anyone else encountered issues with the time stamp in
CRM? While we are on the east coast, the CRM was
originally set-up with Pacific Time as the default. We
realized this and tried to switch all users over to
eastern time. As a result the time reads 5/19/04 3:00:00
AM (only within the SQL view not within CRM itself). Even
worse I had imported data as ET user to a PT server and
the dates were converted to 5/18/04 9:00:00 PM (Which show
up as 5/18/04 in crm when viewed as PT but 5/19/04 when
viewed as ET). Does anyone have a rationale for why
microsoft would allow the dates to ...Line of Credit Account Setup
I have Money 2004 and when I create a new account it does not give me the
option for a Line of Credit type.
In microsoft.public.money, RobertW wrote:
>I have Money 2004 and when I create a new account it does not give me the
>option for a Line of Credit type.
Perhaps those types are not available in the Canadian/Standard
You could call it a credit card.
...Excell 2000 show all lists
i want to show all the lists present in my workbook
i've seen it done but i have no clue where to find the menu
to show and edit and remove names for lists.
let me know if you have an idea where i can find this.
Resolved I was looking for a list of names
I am using an excel spreadsheet and IM to bring in an increase adjustment. I
have 18 different accounts to credit and want one batch with 18 lines. I
keep getting 18 batches with 18 lines in each one. I had set this up
correctly once before but something happened to the integration and I had to
recreate it and I don't remember what I did before to create one batch.
Can anyone please help me with this?
I figured out the problem. I was selecting all 18 rows for the header query
instead of the first 2.
> I am using an excel spreadsheet and IM...Installation Issue
I have just installed CRM 1.2 Professional -
I was able to install the 1.2 client locally.
On a VPN connection, I can't seem to access the server - I tried to
installed the client and it's asking for the website, but it can't be found.
Do I need to allow remote access or some other approach?
See if you can get to the CRM server via a web browser. If you can access it
by name, it's probably related to open ports. If you can't, it's a name
> I have just installed CRM 1.2 Professional -
> I was able to ins...adding portrait and landscape pages to the same Publisher publica.
Can anyone enlighten me on how to include portrait and landscape documents in
the same Publisher publication?
Thank you for any assistance.
> Can anyone enlighten me on how to include portrait and landscape
> documents in the same Publisher publication?
> Thank you for any assistance.
Another idiot too lazy to Google. You don't.
Facon - the artificial bacon bits you get in Pizza Hut for sprinkling
Rotate the page you want landscaped 90 degrees. Adjust to fit.
Mary Sauer MS MVP
news:/...Multiple bank accounts at same bank
We have set up multiple accounts and one credit card at the same bank (TD
Canada Trust in Canada) and it appears that the credit card activity is
downloaded without problem but all other accounts inport into the same Money
account( the credit card).
Is there something simple we missed in creating the accounts?
=?Utf-8?B?VGFmZnk=?= <Taffy@discussions.microsoft.com> wrote on 03 Jan
2008 in group microsoft.public.money:
> We have set up multiple accounts and one credit card at the same bank
> (TD Canada Trust in Canada) and it appears that the credit car...