Printing Checking register
I try to print register but only get balance and check amount but have
no list of check numbers or to who i paid. I have used quicken in the
past and was always able to print what I was seeing. How can I resolve
this problem. i need to send a copy of my register to a company. Thanks
for your help
...Printing Page Numbers
Is there an easier way to assign page numbers to a large
workbook other than to do it page by page? I was hoping
for some global method.
How about grouping your worksheets (right click on a worksheet and click on
"select all sheets") (Or click on the first tab and ctrl-click on subsequent--if
you don't want all the sheets.)
then File|Page setup|Header/footer
and set them all at once.
when you're done, make sure you right click on one of the grouped worksheets and
select "ungroup sheets". Everything you do to one of the group, you do to all
of ...Graphic bars print incorrectly
I have a bar chart where I've substituted an arrow shape for the bar.
(I did this by selecting an copying an auto shape to my chart, copying
it to the clipboard, selecting all bars in the chart and selecting
This looks great on the screen and prints fine in black and white but
when I print in color the arrows become full bars. I thought it might
be my color printer driver but if I print in color to Adobe PDF it
shows full bars instead of the arrows.
Any ideas on what would cause this?
Here's a little more data. It seems to only occur if the shape has
been...Computer freezes when printing mail merge in Publisher
When I use mail merge in Publisher, I can only print about 10 of the contacts
at a time or Publisher freezes. It doesn't seem to matter how large or small
the file size is either. The problem started when I got a new laptop. I
didn't have this problem on my old one, so I'm thinking it has to be a
setting somewhere. Thanks for any advice.
Hi r2knutso (email@example.com),
in the newsgroups
|| When I use mail merge in Publisher, I can only print about 10 of the
|| contacts at a time or Publisher freezes. It doesn't seem to matter
|| how larg...100% stacked column chart shows wrong information
I wonder if someone can help me. I have created a table that tracks the
profitability of a particular project and I’m using the table as a source for
a 100% Stacked Column graph.
The source data for the graph is in three rows:
• B21:M21 - contain the names of the months from Nov – Oct
• B22:M22 - money taken in
• B24:M24 - profit
B23:M23 contains the money paid to supplier each month. I need this in the
table but I don’t need to show it in the graph. I just want to show profit as
a proportion of what we bill to customers on that project.
My problem is that the graph seems to show in...Excel and some disappeared sheets
Anybody has the same or similar experiences :
- I worked with excel file / closed as usually
- new day opened and unfortunatelly some very important sheets
disappeared / why ? Don=B4t know
- I had about 7-9 sheets just now only 3 ones are there but not so
important as another ones
- the file has original size / I quickly looked into file by normal
text editor only for reading
and all relevant data are there, however if I open file by Excel, NO
original sheets or data
- this file is VERY IMPORTANT for me
- why happened ? Don=B4t know since I ask anybody for help
Thanks in advan...office 2000 [excel] cannot open previously OK file. Help
When trying to open a Microsoft Excel Work Sheet that I had accessed modified
and saved to only yesterday [Office 2000] a window pops up with:
"name.xls cannot be accessed. The file may be resd-only, or you may be
trying toaccess a read only location. Or, the server the document is stored
on may not be responding."
Older files stored on the same mediums ;HD, Flash memory or 3.5in. diskette
are accessed with no problem.
This is on a network drive?
...Queries and Charts
Does anyone know why the expressions in queries work fine for reports but not
...Printing In Color
Operating System: Mac OS X 10.6 (Snow Leopard)
I am trying to print a document in word that is color but it is only coming out in black and white. How can I change the color settings on my printer?
Word has no setting to print in color v. B/W -- that's a function of your
printer & its driver software. The settings are available in the Print
dialog in the Copies & Pages List, but exactly where the setting is located
depends to a great extent on what printer you have. Some printers also have
physical controls on the printer, itself, but that isn't common.
...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam firstname.lastname@example.org> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...Data migration - Adventure Works
I have a company where the adventure works db has been used and had a
lot of data populated into the system. We have now purchased MSCRM and
have obtained the company reg keys.
What is the easiest way to get the data from the 1 system to the next?
We will be establishing a new AD domain and users for the new
Data Migration Framework?
Microsoft CRM MVP
"funboy...OL2002 Problem : HELP, SOS, MAYDAY
I have an IMAP account and OL2002 as client.
I have checked for my account ( tools, send/receive
settings, define send/receive groups, <my_account>,
edit) download item description only.
It works only the first time I start OL2002, but it does
not work anymore for subsequent automatic/manual
Please could someone really help me ?
Thank you in advance,
...set print area #2
Where is the "set print area" button in Excel 2002 that was in Excel '97?
> Where is the "set print area" button in Excel 2002 that was in Excel '97?
Are you sure it was "standard"? Only way I could get in was to right-click
the toolbar|Customise and drag it to the toolbar from Commands|File
...Updating a chart Automatically
Hi, i update a spreadsheet with new data from Access
everyweek. I have a chart that displays the last thrity
days, how do i do this automatically, so i dont have to
keep updating the chart manually ?
Thanks in advance Jay
Jay Richardson wrote:
> Hi, i update a spreadsheet with new data from Access
> everyweek. I have a chart that displays the last thrity
> days, how do i do this automatically, so i dont have to
> keep updating the chart manually ?
> Thanks in advance Jay
See www.tushar-mehta.com, Dynamic Charts.
dvt at psu dot edu
...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...How do I set up a 98% baseline across my chart?
I am trying to show on a bar chart the baseline that represents SLA
requirement of system up time of 98%. How do I do this?
You can find information on adding a datum line here.
Andy Pope, Microsoft MVP - Excel
"Deb" <Deb@discussions.microsoft.com> wrote in message
>I am trying to show on a bar chart the baseline that represents SLA
> requirement of system up time of 98%. How do I do this?
...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...line chart with NA() values
12 month line chart, with some values being 0.
I am using an if statement that turns any 0 values to #N/A so they do
not show on the graph (which is what I want).
My problem arises when the 0 values fall in the middle of my data.
So for example:
1) data for all months (Jan-Dec), the line shows across all 12
2) I have data for only 6 months (Jul-Dec), the line starts in Jul and
ends in Dec (perfect);
3) When I have data from Jan-Mar, and Oct-Dec, the line connects
between Mar and Oct. I want 2 distinct lines with no line where there
is no data (#N/A).
gri...Help With Margin Formula
I need help with a margin forumla (calculated from retail). Say I have a
cost of $10.00, and I need the formula to calculate a 40% margin from
retail. So the retail should end up at $16.67. Not sure how to get from
$10.00 to $16.66, I just know the cost and the margin I need to make.
"JR" <email@example.com> wrote in message
> I need help with a margin forumla (calculated from retail). Say I have a
> cost of $10.00, and I need the formul...GETPIVOTDATA data_field help
When I enter a reference to a cell, eg A2, as the value for the data_field item in the GETPIVOTDATA I get a #REF error. However, when I instead type the value of A2, eg 2003, manually into the GETPIVOTDATA formula, it works. Can anyone please help--I want this formula to vary based on what is in A2.
This function is so variable in action, and difficult to handle, that
have given it up in favour of VLOOKUP. In fact, having no problem i
use with pivot tables
Message posted from http://www.ExcelForum.com
Try copying the headings from the pivot table, and pasting them into the
ce...Exchange server crashed, please help....! Need to restore two priv.edb and pub.edb files into one....!
I was wondering if I could get some help with the following problem we are
having on our company.
Here is the scenario; Our Windows NT 4.0 SP4a server running Exchange 5.5
SP4 crashed (Server 1) due to the exchange database reaching its 16 Gig's
max limit. I went ahead and moved some mailboxes' e-mails to a few .pst
files in order to make some space. This worked ok. Then, I decided to build
another exchange server (Server 2) to moved some mailboxes and alleviate the
load. Once the server was ready and configured as part of the current
exchange site, I went ahead and move...Why will my publisher 2003 not print graphics?
I have recently loaded windows 7, and since then I cannot print any graphics
from any publisher document, text and infills print but lines do not! I have
looked at the advance printer settings and the "Do not print any graphics"
box is not ticked.
I have also tried reloading publisher but this did nothing. Any ideas anyone?
Might take a look at the web site of your printer model to see if there are
Windows 7 drivers. Will the document print okay if you convert it to PDF?
There are free converters around. www.primopdf.com is free.
It is always wise to completely remove ...Help!!!!
I am running Exchange 5.5 on NT 4.0 sp6a. Norton Anti-
virus deleted my edb.log file. I have done an on-line
restore with Arcserve 2000 and now my directory service
won't start. getting 1166 internal processing error. I
have been to support and could find anything that helped.
Thanks in advance
You may want to run eseutil /mh <drive and path to your dir.edb and
include the dir.edb > c:\edb.dmp. Find this file and see if your dir is
also inconsistent. If so you will need to restore your dir.
Nan Bennett (MSFT)
Microsoft Exchange Support
Please do not send e-mail...How can I print on 8 1/2"x17" paper?
I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
change the paper size to accept and print anything bigger than 14." any
suggestions would be greatly appreciated
First make the size settings in the Printer Setup. You may need to use the
"mickilena" <firstname.lastname@example.org> wrote in message
>I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
> change the paper size to accept a...Removing text from cells leaving numbers (help with function)
I need a function that will remove all text from a cell and just leav
numbers. Formatting cells to number does not work.
For example if I have:
(Sired] Tennessee 37013 (herein
I just want 37013 left.
Anybody know a function to resolve this
Message posted from http://www.ExcelForum.com
The following will strip the text from the active cell and place the number
in the adjcent cell one column to the left. If there are subsequent numbers
in the original string you will get erroneous results. Put the cursor on the
cell to be processed and run the macro.