How do I subtotal pages in Excel?
I want to subtotal a column per page in Excel 2000, however the page may vary
as I add and delete records. Can anyone help me?
Shouldn't be a problem as XL will automatically adjust it's total
formula as you add and delete.
I'm assuming you are putting in a sum formula ("=sum( cell1:cell2)").
"lshivvers" <firstname.lastname@example.org> wrote in message
> I want to subtotal a column per page in Ex...Combining MS Money files
Is there a way to combine/merge MS Money files (not accounts, but files) into
one file that will display all acounts?
You will have to mentally designate one file as the master file and the
export accounts from the other file to qif file format. Then import the
files all together (use ctrl + click to select when asked which file to
import) into the master file.
Take backups of both files before you start!
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I ha...Opening a unicode CSV file from Excel
I'm currently working on an application that can export data in "CSV"
format, and then launches Excel to view the CSV data. This works
perfectly ok for ascii data.
However now I have upgraded our application to use Unicode I'm running
into problems. When I export data into a unicode CSV file and launch
excel with it's path on the command line I get a "This is not a
recognized format" message. If the same file is opened manually from
Excel the same error is shown but afterwards the text import wizard is
displayed (which works ok).
Currenly the file is 16 ...Excel #81
I need to know the importance of excel and what are the
uses of excel.
Your responce in this matter will be highly appreciated.
There's lots of information on Excel on the Microsoft site:
Qinisile Bukhali wrote:
> I need to know the importance of excel and what are the
> uses of excel.
Excel FAQ, Tips & Book List
...mutimedia messages coming to inbox without attached files
Sending a picture from my phone to email. I use Outlook 2002 to read and send
emails. Message arrive but not the attached picture. My phone company email
site recieves the picture without any problem. Is there a setting in
OUtlook that is stopping the picture?
...Must buy new computer...Ideas?
Hello to all! Finally my over 10-1/2 year old Dell desktop's extreme
slowness has seriously gotten on my nerves and I'm now looking for a new
one. (Surprisingly, it's working pretty well otherwise...)
Maybe this isn't the right forum? But beside the usual things like RAM and
HD GBs, are there things I should be sure to have...or be careful NOT to
have on a desktop? After n ot looking into computers for over a decade I
feel like a Martian in the Earth. lol!
Also, is it possible to transfer to the new one ALL my stuff, including
programs, etc.? Do you thin...Default properties for new folders
How does one set the default properties applied when
creating new email folders? Currently, when I create a
new folder, it is created with the AutoPreview turned on
by default. I'd like to change that do that it is left
off by default. It's something of a pain to create a new
folder and then go in to customize it's properties.
You can do this by editing the Messages view; View-> Arrange By-> Current
View-> Define Views...
You might want to define a new view yourself and apply that view on first
use of that folder.
Robert Sparnaaij [MVP-Outlook]
www.howto-o...I used "save as" but now can't locate original file
I was using a file (November), changed the data, clicked "save as" (December.
Now, November is the same as December. Any possibility there's a temp file of
I believe you have not done as you describe.
If you had a previously saved November workbook open and made some changes
then File>Save As and named it December, November workbook will still be on
your computer in its previous state.
Unless you saved it as November with the changes.
From where did you open November workbook?
It will still be there.
Gord Dibben Excel MVP
On Thu, 1 Dec 2005 1...Excel charts #12
I am trying to format the individual labels on the category axis on an Excel
chart. I want every other label in a different color and bold. But the
entire category axis is formatted. Does anyone have a suggestion? The
category axis is years - 1990 through 2005. I want the odd years to be bold
and a different color than the even years.
When Excel doesn't let me do what I want with a chart axis, I draw my own:
Use this technique to make two different axes, one for even and one for
odd, and hide the default axis Excel draw...Excel memory issues
We have several excel spreadsheets on a network drive that when opened by
any client they receive several errors relating to memory, such as:
Not enough memory
Not enough system resources to display completely
Any ideas? We have increased RAM on server and workstation and page file,
but the users are still receiving the errors.
Did you increase the memory on the client's machine? You never mentioned if
they have enough harddrive space.
"Neil Shirley" wrote:
> We have several excel spreadsheets on a network drive that when opened by
> any client they receive s...Need to Transfer Files Between Money and Quicken
I've got an interesting problem here. I need to transfer files between Money
2002 and Quicken Premium 2004. The first four attempts at having Quicken
read exported QIF files has been a disaster. Quicken is absolutely no help.
Their built-in help is referring me to webpages that don't exist. There is
supposed to be a tool to convert the file format, but the fine print says it
is for converting between previous versions of Quicken and Quicken 2004, but
it "may work" for converting Money files. A Quicken guru says I need to
export Money files to XML in order to bring the files i...New Email Messages
I just installed Outlook 2007 on my new PC and for some reason the new
messages I received can only be received when I press the SEND/RECEIVE
BUTTON. My Outlook at work receives these new mail messages as they are
received. So how can I configure the system to make that happen?
The Trail Hiker!!
There are two settings within the accounts
1) Send on starting
2) Auto send/receive every xx minutes - set this for 10 minutes
"hiker0531" <email@example.com> wrote in message
>I just installed Outlook 2007 on my n...restoring system data from external HD .bkf files
My OS is Windows XP Media edition 2005. I recently reformatted my HD and now
I am trying to restore my Office Outlook files (.pst) plus system settings. I
have been only able to access personal files and folders. I really need the
..pst files. When I run the backup - restore wizard the check marks appear on
the two "C" drives, out of 14,471 MB on the external HD, only about 350 MB
are restored, the field "processed" reads "0" How can I restore the rest of
my system from the external HD?
On Thu, 27 May 2010 14:53:4...Unable to open "New" window to write email.
I am using Microsoft Outlook in Office 2003. It has been working great until
When I click "New" to write a new email I get an error window :
The messaging interface has returned an unknown error. If the problem
persist, Restart Outlook.
I have tried this several times, even restarted the computer to no avail.
Anyone have a solution????
...Prevent new comments on old posts in sharepoint blogs
How do I stop comments on certain posts in a SharePoint blog?
I have removed permissions to the specific post to the lowest possible
access and people can STILL post a comment. If I uncheck one more item in the
list of permissions, the users can no longer see the post.
...excel spreadsheet #8
I have a 2 sheet excel spread sheet that I put together
with varing column widths.
On the top 1/4 of the first sheet (of the 2 part spread
sheet) I need to have different column widths to insert
specific data with different column widths that conflict
with the column widths in the balance of spread sheet.
How do I seperate the sheet to have the column with at
the top 1/4 differ from those on the rest of the sheet?
I treied cut & paste within excel, I tried building the
top part in word and paste to excel. nothing works.
Can this be done?
...Make excel run large spreadsheets faster
For those of you who run large spreadsheets with or without VBA, I think
everyone will agree they are much too slow
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=e1105194-24af-4697-ab5f-b9d62e5140ea&...New Location/New setup
Currently I'm downsizing our office, and moving to a new location. I'm
running MS Server2003 as well as Exchange 2003. Once moved, I will no longer
require the server (since I am setting up a home office).
Are there currently any steps or procedures available to correctly shutdown
one office...and basically setup a home office with no exchange server.
Also I will be removing the current pc's from the Domain, and setting up a
few in a workgroup.
I would like to receive emails from the other employees for time being until
I completely cancel this email account. I already have a...Looking for Microsoft Office Binary File Format or File Signature data
I have an application which obtains numerous "unidentifiable" files
with no file extension, via FTP, and would like to run some sort of
binary filter on it to identify PPT, DOC, XLS file formats.
I did fine this: http://www.garykessler.net/library/file_sigs.html
But it seems a messy way of accomplishing this, and is incomplete. Any
clues as to finding the binary record format and/or file signatures of
Office documents (Office 2000 and greater).
...A Short Video on Adding/Editing New Customers
If capturing customers at the POS is important to you, take a couple of
minutes and watch this video. This application also allows for edit of
Global customer information in HQ installations.
Contact us for detailed info and demo.
It would be nice if you could encode the videos with a more common codec,
and not in wmv format. This requires the GTM3 codec (GoToMeeting). Windows
Media Player 11 doesn't automatically download the codec, and I'm not going
through the trouble to download and in...Transfering Access 2000 file to Access 97
How do I save a Access 2000 file so it can be opened using
Office 97 Access. Is it possible
You will need to convert it to Access 97 as follows:
- Select the menu option Tools > Database Utilities > Convert Database > To
Access 97 file format
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Microsoft Access Support
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the informatio...Excel
I need to insert a space three characters from the right of a piece of text I
have in a cell. How do I do it? I was thinking along the lines of customer
formatting but this is proving troublesome as I'm an Excel novice.
If your piece of text is in cell A1, you could put the following formula into
a helper cell (such as B1): =LEFT(A1,3)&" "&RIGHT(A1,LEN(A1)-3). If you
want to convert the formula back into text, click on B1, press Ctrl+C to copy
it, then click on Edit | Paste Special | Paste: Values | OK.
> I need to in...Cannot Open 2002 Files in 2004
USA Money 2002.
Moved 2002 files to flash drive and tried to open them using Money 2004 and
I get this message "Type your password to access your files." The friedn I am
helping does not ever remember using a password. I guess the only option is
to use the Money 2002 program on the old hardrvie and see if that will allow
us to access the file.
The most typical case is where you are trying to switch regions.
Your second option requires that Money 2002 be installed. This sounds like
you are trying to upgrade a computer. BTW you can have multiple versions of
Mo...How do I activate the new mail button
When I start Outlook, the "New", "forward", "reply" and "reply to all"
buttons are not active which means I can not send mail. I have no problems
receiving mail. Also, on web pages with email links, when I click on them,
the Outlook application is not launched which is almost certainly related to
this. I think I'm missing something very simple here!
Are you in a mail enabled folder? Do you have an active email account
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert...excel #136
I have files in quantrum pro and would like to open them in excel. But they
I'm not familiar with Quantrum Pro. What does it do?
"Liz R" wrote:
> I have files in quantrum pro and would like to open them in excel. But they
> won't popen