Corupt excel file ???
I have a excel file that seems to want to open, but then when it is done
opening, There is no data or blank sheet. It goes though the possess
and say's at the bottom ready opening but then there is nothing and the
screen look's like I just opened Excel but no spread sheet. I then can
go to file open another sheet and it works. (Not the one I wont) any
body help. of coarse we don�t have a backup??? Email:
Message posted from http://www.ExcelForum.com/
First, check to see if the file is actually loaded.
Click on Window and see if it appears at the bottom o...Can Excel generate a 3-D scatter plot?
I want to generate surface plots of the form (x,y,f(x,y)). Should I just go
buy MathCAD, or can Excel manage this?
Andy Pope has 'tricked' one:
But you probably go for MathCad :-)
"zzzfizz" <firstname.lastname@example.org> schrieb im Newsbeitrag
> I want to generate surface plots of the form (x,y,f(x,y)). Should I
> buy MathCAD, or can Excel manage this?
...Excel toolbar button
Is it possible to add a toolbar button to MS Excel programatiacally?, without
Is it possible to add a toolbar button to MS Excel programatiacally?, without
opening excel?, and link it to a macro that already exists in a file?
...Excel VB-Copy formula down until adjacent cell (left) is blank?
Here is exactly what I am trying to do through VB in Excel:
Weekly data pull fills colums A:G. Row count is always different. I am
modifying the data pull through VB, and I have a VLOOKUP formula in cell H2.
What I want VB to do is copy that formula down column H to the last row (with
data) each week. I guess I want it to be dynamic so that as rows
decrease/increase the formula is only copied down to the final row/record.
I know someone out of this smart group will know how to do this!
Thanks in advance!
in a macro
dim lngLastrow as long
dim rngTarget...Faulting application error in excel
I have a PC that keeps getting a crash in excel. It repeats with the
same error each time in the event viewer:
Faulting application excel.exe, version 11.0.8324.0, stamp 4bc93a36,
faulting module excel.exe, version 11.0.8324.0, stamp 4bc93a36, debug?
0, fault address 0x000b035a.
I have tried a repair install. A remove and reinstall. Along with
steps to remove the excel profile.
The crash happens about every other day and sometimes a couple times
or more each day.
This is a guess and may not work, but ...
I've read (somewhere) that most causes of crash...Excel VBA
I have enclosed a timesheet which i want to break down the day
activities by a percentage, so if my sheet says an activity took a
hour then the day column would tell you percentage of a seven hou
Also i want the date column date to change each day. Currently it work
for one day but then the next day it changes all the above cells to th
I have attached the file
Attachment filename: book2.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56396
Message posted from http://www.ExcelForum.com
...In excel when inputting dates 10/4/04 (10/april/04) data converts.
In excel when inputting dates 10/4/04 (10/April/2004) excel converts this to
4/10/04 (4/October/2004) Where can I change the input characteristics.
I have changed the date format to English (UK) and this works when I input
the date in the American format mm/dd/yy but I want to input in the dd/mm/yy
I think I'd try chaning my windows regional settings.
In win98, I'd get to it via:
Windows start button|Settings|control Panel|regional settings applet
Change the short date format to dd/mm/yyyy (I like 4 digit dates--you don't have
to use that part--but put it in d...Excel 2002 Template Wizard
Doe anyone know if the Excel 2002 Template Wizard add-in
will work in Excel 2003?
I don't use xl2003, but I've seen posts that say that it does.
John Fox wrote:
> Doe anyone know if the Excel 2002 Template Wizard add-in
> will work in Excel 2003?
...How to represent a column in Excel
I currently have a formula.
However, the length of both column G and K are not fixed.
The data is retrieved from a remote database.
Is there any other way to represent it ?
One quick-and-dirty way is to just do the whole column, x`like:
It won't be appropriate for Excel 2007, but is there any chance at all you'll actually fill
the sheet to row 65536? It's also considered somewhat sloppy, but you'...When form closes it creates a blank record in the table
I have a form that links to a table called 'Suppliers'. Whenever that
form closes it automatically adds a blank record to that table. Is
there a way to prevent that from happening?
Thanks in advance
<MichaelJohnson168@hotmail.com> wrote in message
>I have a form that links to a table called 'Suppliers'. Whenever that
> form closes it automatically adds a blank record to that table. Is
> there a way to prevent that from happening?
If it only happens when you had the form on a new (blank...Printing EXCEL items in WORD
Excel seems to work better for tables than WORD's tables; yet when a table
created in EXCEL is copied and pasted into a WORD document I caannot get the
gridlines to print. Even thouigh in EXCEL the print gridlines instructions
are checked. What should I do?
I've always apply borders--either in Excel or in Word.
select a cell in the table
Format|borders and shading|borders tab
check the All icon.
The gridlines in Word don't print. Word's help says to use borders. (I just
Old Red One wrote:
> Excel seems to work bett...Outlook
We are on Exchange 2007, Outlook 2007 and Excel 2007. A users sends a
specific spreadsheet to multiple users 2-3 times a week. About once a week,
one of the users tries to open the file and it is corrupted. The original
file is 18K but after he attempts to open it, it reduces to 4K. If he tries
to forward the message, it goes out corrupted. If he saves the file first, it
is fine. But it still becomes corrupted if he tries to open from the
We all use the same anti-virus and this is the only Excel document he has
the problem with. He receives many from various source...Pivot tables, linking to a named range as a source to a pivot table
I have created a main worksheet within the same workbook
of many pivot tables, and I want to use this same
worksheet as the source of information to these different
pivot table sheets off of which I create charts.
I want to use a named range because there are over 4,000
rows in this main worksheet.
I am not sure if I need a "=" to start the reference or
what to do.
I thought I should just use nameofworksheet!database if I
name the range "database", but when I point and click to
the sheet, it is just inserting the name "database"
without the name of the...Sorting table automatically
I have a set of results which are collected into a table B3:AB23.
The data is then sorted by the following macro below.
I would like the table to be automatically sorted without me having to
use the Keyboard Shortcut: Ctrl+y 30-50 times a day.
Can this be done?
' Keyboard Shortcut: Ctrl+y
Selection.Sort Key1:=Range("C4"), Order1:=xlDescending,
, Order2:=xlDescending, Key3:=Range("H4"),
Order3:=xlDescending, Header _
:=xlGuess, OrderCustom:=1, Mat...Excel Add-In loading
Under Windows XP and Office 2003, I have installed an Add-In (xla) and copied
it to the XLStart folder. I can load the Add-In fine, but when I close
Excel, the menu item disappears. Is there any way to load the Add-In so that
I don't have to manually load it each time I close and restart Excel? I did
not have this problem on Windows 2000.
(remove nothere from the email address if mailing direct)
"xlpuzzled" <email@example.com> wrote in message
> Under Windows XP and Of...Excel 2007 Page numbering
Is there a way in 2007 to consectively number all the sheets beginning with
one (1) until ....?
Thank you in advance for your help.
Do you mean consecutive page numbers when printing more than one worksheet?
Select the sheets to print using CTRL + click or Shift + click
Then set up the header or footer with &[Page]
The selected sheets will print consecutively page-numbered.
Gord Dibben MS Excel MVP
On Fri, 30 Jan 2009 14:09:01 -0800, Dottie
>Is there a way in 2007 to consectively number all the sheets beginning with
>one (1)...How do I hide text beyond the last column in Excel?
In the last column of spreadsheet, if the text goes beyond the column
boundary, how is the text truncated in the next cell. I know you can enter
blanks in the next column, and that will achieve the desired effect, but
that's not an optimal solution for us.
Could you just hide all of the columns to the right of those cells?
Does that help?
> In the last column of spreadsheet, if the text goes beyond the column
> boundary, how is the text truncated in the next cell. I know you can enter
> blanks in the next colum...Excel reporting alternatives
I am part of a team currently looking for alternatives to replace Vision XL
which our Finance team uses for ad-hoc reporting in Great Plains version 8.
Although I am still seeking clarification I believe that Vision XL will not
work with GP 10 or Office 2007 which we will soon be upgrading too hence a
need for a replacement. My team will be writing sql reports using visual
studio etc but our Finance team are rather hoping that they can continue
using some kind of excel reporting tool, any ideas would be most hopeful.
One of the benfits of ...ayuda con formula excel
quiero saber se me puede ayudar en eso
praticamente yo quiero una formula da enserir an la celda CANCELLARE
(mira foto para entender)
que quando uno presiona la tecla CANCELLARE se borre todo el contenido
de la linea detras de CANCELLARE o vero ( C9-D9-E9-F9-G9-H9 ) y
trambien se tendrian que borrar en la hoja (tabla de datos ) donde
estan lo mismo valore de ( C9-D9-E9-F9-G9-H9 ) o vero ( A7-B7-C7-D7-E7-
F7-G7 )( mira la foto abajo )
http://img20.imageshack.us/img20/9799/32649272.jp...Data validation causing problems when using a data form in Excel 2
I have an Excel 2007 workbook that includes data validation set on a number
of cells. When using a data form to enter data and I enter an invalid value
on the form field corresponding to one of those cells I receive the
validation error dialogue that prompts me to retry. I enter the correct data
into that field on the form then close the form. My worksheet only has the
data relating to the corrected field entered. All other data entered via the
form is not entered onto the worksheet.
Is this a bug in Excel 2007? I previously was using Excel 2002 and found
that when using a ...lookup table
I have a workbook with two worksheets in it. the first is a list of items a
description and a purchase month, the other is a table by month. I an
looking to create a method where I can select from a dropdown a product and
it will populate the table on the second sheet. Any suggestions?
Without getting too complicated, I would suggest using a pivot table, which
is designed to summarise data. You can find it under the Data heading.
An introduction can be found here:
"Brian" <Brian@discussions.microsoft.com> wrote in mes...Outlook (and Excel) stops working after MSXML installation
I installed MSXML 4.0 as per the "critical updates"
message on my W98 today. After re-boot, when I try to open
Outlook I get message "Unable to open your defauilt mail
folder - the information store could not be opened" and
then "Would you like to open your default file system
folder instead?" - this is no good and I can't find
anything. I can't open Excel either, I get messages about
Visual Basic and when I close it, I get message "This
process will stop the debugger". I now have a shortcut on
my desktop "Microsoft MXL 4.0 parser&...Project data and time imported into Excel
I am exporting date fields from Microsoft Project into Excel, the problem I
am having is finding a way of getting rid of the time portion as it is
interferring with the calculation.
I understand that a date and time is stored as a double, the integer part is
the date and the decimal part is the time. I would like to easily remove
the decimal part of the imported part.
Any help would be good.
You might want to split the time and date into two separate columns.
If your date/time is in A1, you can split them like this:
Format the cell...Form that changes dafualt value in a table
Hi I made a form that has a text box and a command button, and I want to be
able to change the default value in a table, for example the default value in
field “price” is $2.00 I want to be able to change it to $3.00 by typing it
in my form without have to going to the table design view.
So if you got some code for my command button please reply.
On Dec 13, 8:44 am, Jone <J...@discussions.microsoft.com> wrote:
> Hi I made a form that has a text box and a command button, and I want to be
> able to change the default value in a table, for example the default value i...Linking Access data to Excel
I have an Access 2000 database and need to use output from queries to
populate worksheets in Excel (also 2000), to allow me to then carry out
calculations on the data. I need to be able to overwrite the data, so
built the spreadsheet formatting around the query output structure, and
put all calculations in place, before creating links to the queries - I
did this by selecting the query in Access, copying using Copy, then
switching into Excel and creating links via Edit>Paste Special>Paste links.
I initially built an empty database, i.e. built the structure, based on