Prevent new pivot table items from being selected
I have a pivot table that contains accounts and reports sales by account.
Users selected the accounts they want to see and save their spreadsheet. When
new accounts are added to the accounts list, users do not want to see the new
accounts. They only want to see the accounts they selected from a previous
session when they refresh the pivot table.
Does anyone know how to prevent the new accounts from appearing in the pivot
Use another column: Include, with values of Yes or No, and include it in your pivot table, showing
Then when new data is added, enter ...microsoft money #10
I tried to open Money on my computer (version 2003) The original page was
replaced by Microsoft. How did this happen? How to I get my original files?
What "original page"? What makes you say it "was replaced by Microsoft"?
Have you tried opening your original files? (Money File|Open or double-click
on them from Windows Explorer.)
"DR support" <DRsupport@discussions.microsoft.com> wrote in message
>I tried to open Money on my computer (version 2003) The original page was
> replaced by Mi...Error when adding new user to CRM
I need to add 5 new users into CRM. When I complete the first form for the
user information such as Last name, First name, email address, etc, then
click the save button I receive an error page and the following message is
logged in the Application log.
MSCRM Platform Error Report:
Error: The statement has been terminated.
Error Message: The statement has been terminated.
Error Details: Details on this error have not been provided by the platform.
Source File: Not avail...SBS Exchange 2003: Create new user in AD but no exchange mailbox #3
I'm using SBS 2003. Exchange server is SP2.
When I create a new user using Active Directory, it prompts me about
creating a mail box. It says it's creating a mailbox, then it's done.
But no mailbox appears.
In fact, if I use the Exchange tasks wizard, I can create, delete, and
recreate the mailbox--all say successful without an error message. And
yet, no mailbox.
This is even after I reboot the PC and sent email to the address.
Any ideas what's going on?
> I'm using SBS 2003. Exchange server is SP2.
> When I create a new user ...Reconciling the Accrued Purchase Account
I would like to run a SQL query on POP30390 to group the Receipts based
on the purchase orders and sum the debit and credit amounts for Accrued
purchase account index. The difference between Debit and credit
balances should give an idea of such PO / recipts to check further.
Looking at POP30390 I coudnt find any means to link the Purchase orders
with it. Even though Great Plains does allow Multiple orders to be
received together in one receipt, but In my case most of the time
purchase werent combined in Receiving process.
Any help..to figure out a query.
...If my GP Dynamics support CPA's new cheque standard
I am using GP Dynamics 8.0 in Canada, we have Payable Management module
installed. How can I know if my current version support the CPA's new cheque
The CPA's new cheque standard will be launched in July 2007.
Support for the new cheque format has nothing to do with the Payables
module. Rather, it is a function of modifications or changes to the
report that produces your cheque.
On Fri, 22 Sep 2006 10:06:01 -0700, Kane
>I am using GP Dynamics 8.0 in Canada, we have Payable Managem...Money 2004 Upgrade Problem
I've been using Money 2003 small business. When I put in Money 2004 Standard
it converted my files to 2004. I want the full small business functionality
but now cannot open my files in 2003. The error reads:
"Money cannot locate '(file name)' or cannot open it, possibly because it is
a read-only file or you do not have permission to change it or your disk
drive is write protected."
I know the file is not read-only and is not open in another program. I also
have the permission to change files on my computer.
Does anyone have any suggestions for what to do? I'm prett...Does the New Worth Report have a fault
When I calculate my new worth in MS Money 2000 (old
version I know) it adds my assets and liabilities instead
of subtracting them.
For example, if my savings, checking, investments total
$10,000.00 and my liabilities total $5000.00, MS Money
calculates my net worth as $15,000.00. Shouldn't my net
worth be $5,000.00? Shouldn't it subtract my liabilities
instead of add them?
Please let me know if there is a glich in the software and
how I can fix it.
Also please let me know if I am financially inept.
In your example, the net worth should be $5,000.00. You may hav...Problems with reports on Money 2004
I am having problems getting onto the reports page as everytime it crashes. I
have tried to repair using the disk and uninstalled and re-installed and it
still doesn't work. I am told that there isn't a new UK version available so
I cannot upgrade. Can anybody help
In microsoft.public.money, Jayne Morris <Jayne
>I am having problems getting onto the reports page as everytime it crashes. I
>have tried to repair using the disk and uninstalled and re-installed and it
>still doesn't work. I am told that there isn't a ne...How do you replace old data with new data without creating a new .
I have existing pivot tables and I want to replace the data source worksheet
with new data and the pivot tables update with the new information. I have
replace the data source but the pivot tables didn't update.
Hit the "Refresh Data" in the pivot table toolbar (looks like an exclamation
> I have existing pivot tables and I want to replace the data source worksheet
> with new data and the pivot tables update with the new information. I have
> replace the data source but the pivot tables didn't update.
So...try out of new e-mail
Please let me know if you get this e-mail. Thanks, Mom
I did get this email.
But you also sent it to a public news group!
"Helene Meyer" wrote:
> Hi, Mike,
> Please let me know if you get this e-mail. Thanks, Mom
...ActiveSync does not sync new mail without intervention
I have a SBS2003 with Exchange 2003 SP2. The computer is behind a Watchguard
firewall. ISA is not running. OWA & OMA both work fine via https from either
mobile devices or computers.
From Windows Mobile 5 works fine if in cradle (I'm assuming that activesync
notes & tasks syncing keeps outlook open) but if remote
Initial sync - works fine
Send mail - works fine
read mail messages - works fine
sync'd message deleted - works fine
new mail - only works if mail already read
Activesync shows that it has synchronized all items without error but new
messages do not sync!
If a ...Money 2004 Backup file
Is there a way to specify a folder in the 'backup' options in Money 2004?
For instance, I would like to backup to my zip drive which is drive R. But
it doesn't give the option to specify a folder in that drive, just saves it
in the root folder.
In microsoft.public.money, Dan wrote:
>Is there a way to specify a folder in the 'backup' options in Money 2004?
>For instance, I would like to backup to my zip drive which is drive R. But
>it doesn't give the option to specify a folder in that drive, just saves it
>in the root folder.
...My computer has stopped recognizing my memory card
This just happened today. The card was purchased the day after Thanksgiving
so it's very new. It is a 4GB SD card from HP. I don't believe this is a
hardware problem as my digital camera Lexar 1GB Memory Stick Duo card and
adapter worked just fine today in the same slot. There has been no damage to
the card. It has a write-protection lock on the side and I've tried the card
with and without the lock on - neither way worked. I've also checked "My
Computer" and confirmed that the computer is not listing my card as a drive
any longer. I really need to get t...Import data from Money 2002 to Excel
I'd like to import some transactions history from Money
2002 into Excel. Does anybody know how I can do this?
In microsoft.public.money, Nick wrote:
>I'd like to import some transactions history from Money
>2002 into Excel. Does anybody know how I can do this?
Prepare a report in Money and right-click into it. You can copy and
paste or choose Export....
For more sophisticated information access, search Google for
...Money 2007 deluxe backup issue
for some reason Money is breaking up my backups to my 4gb usb flash drive
around the 3 mb area - i have compact data checked - regular files are 8 & 12
are there settings to change to prevent this from happening
there is plenty of space on the drive
it names the file xxxd1
when i used my gigabank 8gb drive it did not do this but alas it died
when i just try to continue on the 4g it says already used insert me medium
In microsoft.public.money, tony wrote:
>for some reason Money is breaking up my backups to my 4gb usb flash drive
>around the 3 mb area...Can Money store bill balances?
Can money store my bill balances? For instance if I only partially pay a
bill, I'd like to see what my balance is.
Only if you create a liability account, record the bill as a liability, then
pay all or part. The balance of the liability account is the balance of the
"BDK" <BDK@discussions.microsoft.com> wrote in message
> Can money store my bill balances? For instance if I only partially pay a
> bill, I'd like to see what my balance is.
See also http://u...Money 2000 Windows XP SP2 Password problems
* I have reformatted my hard drive (On a Compaq Table
TC1000) & reinstalled Windows XP Pro Tablet.
* I have then installed the Windows XP SP2. I then
restored my backups, which included my mny data file from
* I then (amongst other software installs) installed
Money from the original CD.
* When I tried to start Money, it asks for the password
as usual BUT it doesn't accept the usual password.
* I have checked that it is the right file, checked Caps
Lock, typed carefully several times - to no avail.
* Are you aware of any problems with Money 2000 & SP2? I...adding holidays to a new calendar
I have set up a new calendar that I want to share with my department and I'm
trying to add legal holidays which were already on my personal calendar. Even
though I'm viewing the new calendar, the holidays got added to the personal
calendar. I tried deleting all the holidays and then, with both calendars
open, putting the holidays back in, but again they were added only to the
personal calendar. Anyone know what to do?
Add them to the personal calendar and copy (or move) them to the other
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-t....OST full (2 GB) during POP collection = all new mail lost?
The subject says it all... Outlook 2003 in Cached Exchange Mode
(non-Unicode, i.e. inheriting old 2 GB limit) on Windows XP. Was working
offline, collecting two days of POP3 mail, and at the end of the collection
I got the error message saying that the .ost file had reached the size
limit... Very stupidly, Outlook 2003 (!!!) _deleted_ all mail from the POP3
server before making sure that the same had been stored properly, so it
appears to be all lost now? Just out of curiosity, where did Outlook write
this data as it was being collected? Was it being appended to the .ost file?
I tried ...Money 2005 #34
Perhaps I don't quite understand how to use Money, it's all new to me but
this is my question, When I create an invoice and I receive that invoice into
my business account it shows as "payment for invoice" but when the check for
that invoice is deposited into my bank it shows up as 2 deposits when I
download info from the bank. I can't get them to "match" as the "payment for
invoice" does not show as an income. Am I missing something?
Any help will be greatly appreciated, MtnMaine
I'm sorry to hear that you are having this problem because...Cant see Default Public Folders on New 2003 Exchange
We have recently installed a new W2003 Exchange 2003 server into our
domain. The domain already had an Exchange 2000 server installed. The
default public folders on the Exchange 2000 machine can be seen under
ESM and by Outlook clients.
We have created an additional new public folder store on the new 2003
server, however, the default Public folders on the new 2003 server
cant be seen by mapi clients ie Outlook. Additionally any folder
created under the Public Folder tree on the 2003 server under Folders
does not appear under the First Storage Group > Public Folder Store >
Public Fol...Explanation of Money Performance Report
If i run a perfomance report there are 2 columns for judging performance -
"%Rate of Return" & "Annual % Return". I am having a problem understanding
the meaning of each column.
If I run the report for exactly 1 year then both columns show the exact same
numbers for indexes such as Dow Jones Indutrial Average or Nasdaq Composite
which I have in my watch list. In the same report for exactly 1 year the 2
columns have very different numbers for my stocks and mutual funds. For
example I have a mutual fund which shows 1.28 for % Rate of Return and 21.32
for Annu...Moving Exchange DB's to a new server (different name)
In a DR test, we moved SG's to a new server, different server name,
same SG and MS name. MS mounts, can not connect to mailbox. Delete
mailbox, create a new one, we can then connect. Delete this mailbox,
reconnect to the original, and now we can connect.
How can we accomplish this in bulk?
In other words, after doing a system state restore of AD, then a system
state of Exchange, restored MS file, mounted, etc. We were unable to
connect to these mailboxes. I am assuming this is related to GUID's.
Users in AD specify a server by name. When you say that you move mailbo...New computer, outlook locking up
My boss was having alot of problems with an old 1.5GHz HP laptop, so he asked me to find a new one for a good price.
The best price range I found was the $700 dollar range (best bang for the buck). He got a Dell 2.3GHz P4 Dual core, 3GB RAM, 500GB HD, Windows 7 Home premium.
Now what sucks is that after importing all his old emails into outlook, everytime it goes into send/receive, outlook freezes for a little bit. I was told earlier that my method for importing emails (just replacing the PST, rather than Data>open) was not good practice, but could that be causing these pro...