How can i change the default line weight in an excel chart
I select a heavier line weight for a Pivotchart graph so it is easier to see,
however every time i change something on the graph from the drop down box the
line weight goes back to it default (lighter) weight.
...Export from Oracle into Excel, "Open" is not an option in XP
In a nutshell:
New computer running XP Professional, I was using W2K to export data
from Oracle, and into Excel.
The previous options to get it into Excel was to click on either
"Open", or "Save" from the dialogue box. I'd select "Open", and a
resultant list of apps would allow me to select Excel as the place to
export to, and would subsequently populate a new Excel sheet with the
exported data. Nice.
Now. . .with XP, the options presented do not include the option to
"Open", (only "Save" or "Cancel" appear). I can save and th...converting PDF to Excel Sheet?
Hello, I would like to convert a PDF to Excel using a simple linux
command line tool. Anyone know if that is possible? The tool coul
also be a windows tool, but I am looking for a tool that is completel
automated, with no user intevention.
The reason is that I have a program that downloads PDFs every hour o
so, and I would like to convert that pdf to an excel sheet so i coul
grab data off it easily.
Or maybe, does anyone know of an easier way to grab tables informatio
Message posted from http://www.ExcelForum.com
Take a look at
PDF and Excel
http://www.mvps...Word 2000 with Excel 2003
Greetings from humid Southeast Texas.
A friend of mine (who is not incredibly computer literate) has Word
2000 installed on her machine. Yesterday she went out to buy Excel,
and she bought Excel 2003. If she installs this version of Excel will
it affect the current Word 2000 installation?
No, it shouldn't.
On 25 Sep 2004 14:34:28 -0700, email@example.com (Andrew C. - Houston, Tx,
>Greetings from humid Southeast Texas.
>A friend of mine (who is not incredibly computer literate) has Word
>2000 installed on her machine. Yesterday she went o...Moving spreadsheet rows with photos Problems in Excel 2007
I have an inventory worksheet in Excel 2002. There is a photo in one cell in
each row that needs to move with the row. I formatted each photo to move and
size with cell, and had no problems. Have just had to change to Excel 2007.
I can move the row by cut and insert cut cells, and the photo moves with it.
BUT the problem comes with the rows above the cut cells - the photos move
down into the blank row left by the cut row when moving to another sheet- so
the photos left are not with their original rows and descriptions. I have
looked at all the options that I can find (steep learning...Problems With Excel Spreadsheet
I am having problems with an Excel 2000 spreadsheet.
The spreadsheet is very large, and when I leave the spreadsheet open for
about 10 minutes, 12 of the rows, accross the page of the spreadsheet will
collapse or overlap.
I will close the spreadsheet, making no changes and reopen the spreadsheet
and the spreadsheet look normal.
What could be causing the collapse or overlapping of the rows?
Video driver up to date? Check the manufacurers web site for more
current version. Possible the system is attempting to start the screen
saver and failing?
> Hell...cannot open excel file
I go to open an excel spreadsheet that was working perfectly fine on Friday
(it is now Monday), and I get the following error message (regardless of
"EXCEL.exe has generated errors and will be closed by Windows.
You will need to restart the program.
An error log is being created."
I did a search of all "*.log" files on my computer, and the only one
modified at the same time as the error is drwtsn32.log. Here's the entry I
get from the log file:
"Application exception occurred:
When: 6/6/2005 @ 10:28:51.290
...how do I make Excel default to General number format?
I have installed Excel 97 but the General cell format insists on formatting
as the number format with two decimal places.
Is the number you enter already a two decimal number? General removes any
type of formating, and represents the contens as WhatYouSeeIsWhatYouGet
> I have installed Excel 97 but the General cell format insists on formatting
> as the number format with two decimal places.
You may have accidentally changed the "Normal" Style. Go to Format |
Style... and make sure "General" is applied to the "Normal" style.
...How do I insert a picture within an Excel comment box?
How do I insert a picture within an Excel comment box?
There are instructions here:
Roy White wrote:
> How do I insert a picture within an Excel comment box?
Excel FAQ, Tips & Book List
...Excel Opening with Review Page 1940410 of 1940411
Am using Excel 2000 and OS (x64) Vista Home Premium with 4gb RAM.
More times than not when I attempt to start Excel it defaults to a
page with banner containing the above heading, Ready in the top
left corner and a number of 'columns/ panels' on the right side of
The ONLY actions that are possible are page resizing and closing.
As stated, not consistent, say 4 time out of 6.
...excel and publisher
I am experiencing some troubles when printing cell borders from an excel
worksheet, pasted in a publisher document. Do you have any suggestion to
solve this problem?
Are you applying the cell borders in Excel? What happens when you print?
Mary Sauer MS MVP
"IMMA" <IMMA@discussions.microsoft.com> wrote in message
>I am experiencing some troubles when printing cell borders from an excel
> worksheet, pasted in a publisher documen...why won't excel allow me to add more data to a chart?
For some of my data I skip days for collecting it so I use the shift key to
click on the days I do want in the chart. I have been doing this for awhile
but now that I'm obtaining more points it has simply stopped letting me add
data points. When I click on the one where it stops collecting it erases all
of the others I have clicked and makes a stop noise. I need to add more data
so why won't it let me??
There is a finite limit on the length of the series formula, ~1024
So this example is for a series with 3 data points in cells A2:B4.
=SERIES(,Sheet...Copy data between 2 instances of Excel
I have 2 windows of Excel with data. The data are
separated (not in one workbook). I would like to copy the
data from one Excel to another via VBA or Macro.
How can I do that ?
If you look at the Object Model you'll see that Workbook is a
collection. Any open workbook should be part of that collection. So, if
you only have these 2 books open you should be able to switch from
workbook(1) to workbook(20, using the sheets collection, and the cells
collection, ranges, etc to grab the data from one book and copy or move
this to the other.
Workbooks(1).Sheets("...Can't open excel or word documents (says insert sm bus cd?)
I have been running Windows XP for over a year without a problem, but now I
can not open any of my Excel or Word or Outlook documents because it says
that I need to insert my small business cd. I don't have that cd. This has
happened once before and I just used my system restore function and it was
fine, but that won't even work this time. HELP!!
~~Angela @ firstname.lastname@example.org
...Unique records in Excel
does anyone know how to ensure Unique data when making entries in an
Excel spreadsheet ? Say Part Numbers or account numbers etc
gilsondg's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15878
View this thread: http://www.excelforum.com/showthread.php?threadid=273641
There's a method using Data Validation and COUNTIF. Debra
Dalgleish's website has an example of how to set this up:
Atla...How do extract cells from hundreds of excel files and put in one n
I need to extract expense totals from employee expense reports and put in to
one file for import then in to the payroll system fo reimbursement.
Lots of unanswered, but needed information with this question. Generally
this can be done relatively easily, with a big "IF" - and that IF is whether
all of the files you'd be examining (the employee expense reports) have the
same format, content and layout.
Get in touch with me via email through (remove spaces)
Help From @ jlatham site.com
and we can gather some more information and probably have a solution in your
han...Automatic Disable of Autoformat in Excel without selecting range of cells
Please help on how to automatically disable autoformat in
excel without specifying the range of cells that do not
Do you want Excel to stop copying the formatting from rows above? If so,
you can do the following:
1. Choose Tools>Options.
2. On the Edit tab, remove the check mark from
'Extend list formats and formulas'
3. Click OK
> Please help on how to automatically disable autoformat in
> excel without specifying the range of cells that do not
> need formatting.
Excel FAQ, Tips...How-To: Select and Display Combo Box choice with VBA
How To: Using a value from another field I would like to display a certain
selection in a combo box. For example if a user selects 'X' then I would
like to display ITEM(3). What combo box properties/methods should I be using?
Use after update event on the item where the user selects "X".
> How To: Using a value from another field I would like to display a certain
> selection in a combo box. For example if a user selects 'X' then I would
> like to display ITEM(3). What combo box properties/methods should I be using?
My questi...update links in Word from Excel
I have many, many Word documents where some fileds are linked to cells on an
Unfortunately I need to change the path of the Excel worksheet and just
realized that all links will break!!!!
Is there an easy way to replace the path of the Excel worksheet in the Word
documents without having to do it manually (4/5 links per document.... 200
Many thanks in advance for your precious help.
Check out my Field Link Updater, at:
http://lounge.windowssecrets.com/index.php?showtopic=250058&st=20&p=...Excel hangs at Spalsh screen
I am running Office Xp-sp3 on Windows XP pro.I updated Norton Anti virus
Corporte edition version 8 to 9 and my problem started ,excel freezes at the
splash screen.All other office products works fine.cntl Al del will not work
to close excel.I can start excel in safe mode,but cannot change addins and if
I attempt to do it hangs forever.But I can close excel,once closed it says
"please wait windows is configuring Micosoft office xp" and asks for the
pro.msi from the installation package.Later on I disabled Norton auto
protection.Excel opens normally.But when I restart same pro...Conditional import of Excel sheets
Hi, maybe someone can help me with the following: on a weekly basis I
need to import 3 Excel files into an existing empty table (I run a
delete query on this table before the import). The Excel files are
stored in the same folder every week. Each file has a field showing
[Current Year/Week No]. The three files show the current week for
year, previous year and the year before the previous year. How can
instruct MS Access (2003) to look up this field and to import only
approrpiate files (i.e. the files that refer to the reporting week)? I
a calender function from which the u...Excel 2003 - VBA
Is there a way to get the "Y" labels to show up on the right end of the
chart, rather then the left?
The Crosses property set to xlMaximim should do it,
.Crosses = xlMaximum
.TickLabelSpacing = 1
.TickMarkSpacing = 1
.AxisBetweenCategories = True
.ReversePlotOrder = False
Andy Pope, Microsoft MVP - Excel
"Craig Brandt" <email@example.com> wrote in message
Assume that I have the following data:
(Column A) (Column B) (Column C)
LNAME FNAME CODE
Smith John 123
Jones Michelle 456
Taylor Wilbur 789
White Tom 321
Smith Elaine 654
Brown Robert 987
Let's say, that in Column D, I would like to alphabetize the last name
that appear in Column A (I can do this without any problem).
Furthermore, in Columns E and F, I would like to l...Excel changing date format after VB has run
I have a sheet 1 with a combo box and a blank field. When something
is selected from the combo box a date gets populated in the blank
field. The date is custom formatted as mmm-yyyy.
On sheet 2 I have a table with the options in the drop down box and a
date next to them. When a selection is done, the code does a VLOOKUP
and populates the data in Sheet 1 in the blank field. Dates are also
mmm-yyyy in the Sheet 2.
The problem is, say the date in Sheet 2 is 01/12/2010 displayed as
Dec-2010. When it is put into sheet w, it flips it to 12/01/2010 so
says Jan-2010. Any idea w...EXCEL Maximum
Does anyone know the approximate number of lines of data that Excel can hold?
I have heard the number 65,000, but need to validate.
Excel has 65,536 rows and 256 columns. Look in help under Specifications.
"Tom" <Tom@discussions.microsoft.com> wrote in message
> Does anyone know the approximate number of lines of data that Excel can
> I have heard the number 65,000, but need to validate.
Your post from 3 minutes ago was answered by myself.
What a waste of time that was.