Remove page break in Excel?
How do I remove a manual page break in Excel with Office 2003?
Select a cell below the page break then insert, remove page break
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Page Breaks in Excel Removal" <Page Breaks in Excel
Removal@discussions.microsoft.com> wrote in message
> How do I remove a manual page break in Excel with Office 2003?
...Creating and Organization Chart from and excel file
I was able to create an org. chart awhile ago and now when I try to use the
org. chart wizard and select the excel file I get an error "cannot read
names". I have excel and visio 2003. Can anyone help???? I want to include
4 fields from from excel file (name, title, department, reports_to). Help!
Have you tried creating an Excel file recently? Perhaps there's an issue
with your existing Excel file. I'd try generating a dummy file using the
wizard, and then try importing it iback nto a new Visio file using the
wizard. If that works, then you may want to cut / pas...creating a table automatically
hi this is my first post, i'm fairly new to excel & i was hoping someone
could help me out.
i'm doing some computer work for my uncle & as i was going through
everything that needed doing & i came accross this excel problem. I'd
already created the document which is an operational status report.
when he asked me to set it up so that a section of the report would
automatically appear on each new page of the document. he's given me a
list of the cells he wants to appear automatically. the list is a box
from the cell A8 down to the cell N17.
within the box is at least...Automatic Calculation #2
Why is automatic calculation keeps running even though there is no
modification done in my spreadsheet?
What makes you think that excel is recalculating?
If it's because you see Calculate in the statusbar, it could be...
XL: Calculate Message Remains in Status Bar If 65,536 Formula References
"Lucie Ch�nier" wrote:
> Why is automatic calculation keeps running even though there is no
> modification done in my spreadsheet?
> Lucie Ch�nier
Dave Peterso...Quirky recent file list #2
I do tend to open from Windows Explore more then File>Open. But I am
saving the file.
It's more that it is annoying when I close a file by accident and don't
quite remember where it got saved on the server.
SPenney's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1079
View this thread: http://www.excelforum.com/showthread.php?threadid=267592
Well, I guess you weren't the only one who wanted this behaviour
If/when you upgr...Opening a new instance of Excel
I am using multiple monitors for work and it is great! Is
there a setting that I can use so that it opens each new
excel file in a new excel window so I can drag different
ones to each monitor? Is there a similar setting for Word?
I am using Excel 2002 and Word 2002.
Yes, you can check the Windows in Taskbar checkbox in
Tools; Options. This is on the View tab for both Word
>I am using multiple monitors for work and it is great!
>there a setting that I can use so that it opens each new
>excel file in a new excel ...VBA from another app: Suppressing Excel confirmation dialog?
After creating/formatting several worksheets from MS Access, I'd like to delete
the "Sheetn" worksheets that got put there when I did a .WorkBooks.Add.
I avoided using them because I'm not sure how/why they are created - i.e. maybe
some user's defaults would only create 1 empty sheet or none.
So, form MS Access's VBA I'd like to do:
On Error Resume Next
On Erro...how do I add times in Excel and result in hours & mins
I want to insert a time when I start work and a time when I take a break,
then a time when I leave work.
Following that I want to be able to add up the amount of hours that I have
This will enable me to plan my week ahead and ensure I only allocate a
specific amount of time to a project.
Microsoft MVP - Excel
"Rty Shaw" <Rty Shaw@discussions.microsoft.com> wrote in message
>I want to insert a time when I start work and...Office:mac v.X #2
Operating System: Mac OS X 10.5 (Leopard)
I have subject version of Office. I know that there must be updates to this so I can bring this up to date but I can seem to find the ones I need to start the process. Can someone get me to the beginning? Thanks!!!
You can get the Office X 10.1.9 update here:
On 3/30/08 3:09 PM, in article firstname.lastname@example.orgR9absDaxw,
"AWOLGolfer@officeformac.com" <AWOLGolfer@officeformac.com> wrote:
> Version: v.X
> Operating System: Mac OS X 10.5 (Leopard)
> Processor: intel
&g...Importing Data into an Excel Pivot Table via Access
I have set up a query in Microsoft Access which is linked to our AS400
server. I have created pararmeters within Access which asks for certain
fields which works. I then go into Excel and create a pivot table with the
external data source that I have created in access. When I go to enter a
pararmeter within Microsof Query I get a reply saying that "Parameters can
not be used with this Query", what I want to do is setup a parameter on the
Excel spreadsheet which then goes and gets the data i require from this
parameter. I would be very grateful if someone could help me with thi...Illegal operation error while printing EXCEL or WORD Files
I am facing an illegal operation error when i try to print any file from
excel (any no. of pages), this happens in stand alone printer as well as a
When we press the print button, it flashes this message, but still prints,
but once the printing is completed, i will have to restart the PC. Due to
this error other applications PRINTING also will NOT HAPPEN and the only way
out is, restart the PC.
This happens not only in EXCEL, it happens in all the MS applications
(outlook, access, front page, powerpoint also).
When I check the print manager (before restart),...Emailing in excel 2003 02-26-10
If i type in the cell A34: neil.Holden@test.com and press a button is it
possible to email to the address of what ever is in A34 is?
The email body should say: this has been submitted for cell B34 and todays
Check out Ron De Bruins "Send-Mail" tips:
"Neil Holden" wrote:
> If i type in the cell A34: neil.Holden@test.com and press a button is it
> possible to email to the address of what ever is in A34 is?
> The email body should say: this has been submitted for cell B34 and...Exchange 2007 Evaluation version #2
Can I install it on 64 bit platform and run it as production?
On Fri, 23 Feb 2007 09:55:13 -0800, RG <RG@discussions.microsoft.com>
>Can I install it on 64 bit platform and run it as production?
There isn't an evaluation version as such.
You can install Exchange 2007 without a key for 120 days.
...Does anyone have a dashboard gauge (speedometer style) for Excel?
I am trying to create dashboard charts from Excel data and would love other
templates not available in Excel today - speedometer charts, multi-dimension
comparitive charts, charts that build information overlays.
I regularly create these in a manual way for executive and customer
summaries but would appreciate the ability to automatically generate these
types of charts allowing for real time viewing of "what if" scenarios.
Steve, there are tons of these things out there to review, few better than
Andy Pope has put together...Installing office 2000 disk 2 with publisher on upgraded windows x
I can not get disk 2 to install. It preloads then as files start to copy, it stalls then ends with error message. this is office2000 professional 2 cd set.
everything else works exept publisher and its components.
What is the error message?
MVP Microsoft [Publisher]
"cugolfn" <email@example.com> wrote in message
>I can not get disk 2 to install. It preloads then as files start to copy,
>it stalls then ends with error message. this is office2000 profess...Excel Crash
I use Excel and Word 2003 using Windows NT. I've kept some files on a jump
drive so I can work on them at home. I attempted to work on a Word documents
which had an Excel worksheet inserted in it. I tried double clicking on the
worksheet to edit it and Word and Excel shut down. Now when I attempt to
open Excel at home it asks for my Office XP Professional installation cd. (I
have Office XP at home with Windows XP). I'm having a hard time locating my
original discs. Does anyone have any suggestions or experience anything like
...How do I create a pivot table if the pivot table icon or menu ite.
If rhe pivot table icon ...??? Please clarify in the body of the message.
"Lynn@WS" <Lynn@WS@discussions.microsoft.com> wrote in message
...EXCEL TROUBLESHOOTING #2
I have an excel file (2000 format), that after I made a
number of changes is causing me problems when I re-open
the file. Windows task manager goes to 100% CPU
activity, and i cant do anything within the excel file.
However, if I set recalculation to manual before I open
the file, all seems fine.
Obvioulsy I have a problem. But how do i find that
Thanks in advance.
I have had some experience running large spreadsheets lately. Above a
certain size, the recalculation time seems to climb very fast. While Excel
is recalculating, you can't do anything anyway.
Best in my v...Excel Edit F2 button changed for Mac???
Switched to Microsofts version of Excel for Mac. Can anyone tell me
what keystroke allows me to edit a cell? Before I switched to a Mac
it was the F2 button. Please help. Thank you.
See the answers in the m.p.mac.office.excel newsgroup.
In article <firstname.lastname@example.org>,
> Switched to Microsofts version of Excel for Mac. Can anyone tell me
> what keystroke allows me to edit a cell? Before I switched to a Mac
> it was the F2 button. Please help. Thank you.
...Excel Cells Contents to HTML Pages
I have an excel sheet which has two columns.
Column 1: PageName
Column 2: HTMLCode
PageName has information like: OurServices.htm which is the name of th
HTMLCode clumn has actual HTML Code like:
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html
charset=windows-1252"> ...In Excel program shows a broken line and don't know how to get ri.
I am trying to put in entries in Excel program and when I go to Print
Preview, it only shows part of the entries I put in. When I go to the last
entry that it shows in Print Preview, there is a broken line between it and
the next entry. I don't know what I did. I could use some help
You probably have multiple areas selected for your print area.
you can check this by <view><page break preview>
One possibility to correct this would be
<file><print area><clear print area>
or specifically select the area you want printed and
<file ><Print area>...how to divide a numbers in a table of data by 1,000, all at once
I've noticed in some spreadsheets that numbers are displayed as
rounded...i.e. so that one isn't looking at 1,403,333 + 2,333,999 etc. but
rather 1403 + 2334, etc. with a note at the top that says "000's".
In one step, how can I edit all the numbers in a table so that they show to
the nearest 10,000 (i.e. 1403 +2334), without dividing them one by one by
Or, to go at it from another angle, how do I divide each # by 1,000?
The ROUND feature requires that I create a new table. Not exactly what I'm
Enter 1000 in an unused cell.
Subject: Chart - Title Widths
Date: Tuesday, February 03, 2004 12:43 PM
Chart - Title Widths
Does anyone know how to find the width of a title/axis title?
...Upgrading from Exchange 2000 Standard to Enterprise Cal ? #2
I know the upgrade process from exchange 2000 standard to enterprise
seems pretty straight forward. However, I have a cal question. Are my
standard cals still good with this upgrade. Say I have right now
standard 2000 with 30 cals. If I upgrade to Exchange 2000 Enterprise
with 25 cals to pass the 16mb limitation.
Would I then only have the 25 cals or 55 total cals?
...Does anyone know where I can download EXCEL.MSI?
I am missing my Excel 2002 CD, and can't install Office Update Service Pack 3
without this file.