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...merging pictures into a document template
I need help inserting a code on the data source for a merge that involves
photographs. The mini-project is to take data and picture unique to each
document. I did some instructions but I guess I"m such a newbie that I can't
figure out where to start in this process. I'll paste the instructions below
so somebody can tell me exactly, from the first step and every step til the
end, how to do this. For me, there isn't enough info for me to follow the
directions. I get stuck at #3. Specifically, "by nesting the merge field in
an IncludePicture field." Where ...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...How to generate a truly empty cell
"" generates a zero-length string, not a truly empty cell. This is
causing problems elsewhere. I'd like to find an output for an IF
statement that will give me a truly empty cell. The current formula
Any ideas? If it involves a macro (as I think it might, having read
other posts), please explain how to implement it.
<This is causing problems elsewhere>
It shouldn't. Don't use ISBLANK(A1), use A1=""
Microsoft MVP - Excel
"paulkaye" <paulmjkaye@gm...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'...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...Outlook Rules not working with new Exchange Server
We recently (last week) upgraded our Exchange 5.5 server with a new machine
running Exchange 2003. Since that change, a few clients who use Outlook Rules
to forward messages to other email addresses have noticed that those
messages are no longer being delivered. We have clients using Outlook 2000
and some using 2003 - it doesn't seem to matter which version of Outlook
that's being used.
The rules work just fine for placing specific messages into specific
folders, but anytime that a message is supposed to be forwarded to an outside
email address, it is never delivered.
Any ide...Why doesn't indirect work with a dynamic range created using offse
Has anyone else experienced this issue or I am doing something wrong.
I have a series of dynamic range names defined using offset. For example
the name USCities is defined as =offset(AA1,0,0,Counta(AA:AA),1) and the name
Europeancities is defined as =offset(AB1,0,0,counta(AB:AB),1)
In column A, dataentry into the cells is limited to USCities or
In column B, I want to limit data entry to the range name appearing in
For example if USCities is selected in A1, data entry in cell B1 is to be
limited to those cells forming the USCities range name.
I have tri...Project expenses & timelines
We're planning some remodeling - does anyone know of a template or tool to
track expenses and / or events - trying to get organized before it all begins.
...Match Duplicate Accounts doesn't work?
I just recently upgarded my Money 2004 to 2006 Deluxe. To take advantage of
new features, I started setting up the online services for my checking
account. I was able to have Money establish a connection w/ my bank and
login w/ my supplied username and password. Then I got to the part where
"Are you already keeping track of any of these accounts ..."
- I'm not sure
So, I select Yes because I have indeed already set up that account (and have
many years worth of data in it!). Then I click thex Next buton whic...DLookup Not Working
I have a form i want to create a DLookup where I get the Last_Name on the
tblUserNameTest when the field txtUser on the active form equals the
User_IDon the tblUserNameTest table.
I have this and it is not working what am I doing wrong?
=DLookUp("[Last_Name]","tblUserNameTest","User_ID = " & [txtUser])
Whatever you can do to help would be greatly appreciated.
What data type is the field User_ID?
Your code indicates it is a numeric data type.
If txtUser is a form control on the current form, you should be qualifying
it with either Me. or...Query
How could I force the query results to output to a specific format/template?
The reason for this is that certain values don't exist in certain date ranges
within the data pool. I need those values to be included in the query
I have tried linking another query(tried a table also) with the template to
the query that calculated the results.
Is there something I should consider when doing this? A better way?
Create a new query that includes the table that contains the domain of
values you want to appear in the output and join that table to the existin...Hyperlinks to pdfs and word documents are not working
My Access database was recently upgraded to Access 2007. Now all of the
hyperlinks I have to pdfs and word documents are not working. In browsing
"external data" I see that I can link to text files and excel files, etc.
Please explain why my links to pdfs and word documents no longer are working
and how I can fix them.
Try to eplain a little more, what do you mean by not working? Do the links
react but present you with some kind of warning. In what way were the links
Have you set the directory where your files reside as trusted in the
trus...How do gift cards work?
I'm new to MS POS 2.0, so please forgive me if this is off base... I want to
be able to sell and accept gift cards in my store. I do not want to use
pre-loaded Visa cards, but rather just a custom card that I will have
someone build for me. What is the right way to go about this? I'm thinking
that I need to get cards with a unique code on their mag-stripe which I can
register in MS POS 2.0 with an associated $ amount. Is this correct?
MS POS doesn't support Gift Cards, only RMS.
"Randy M" <RandyMagnuson@hotmail.com> wrote in message
news:%23pJNqwRFI...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)...LDAP lookup not working with Outlook 2003
I have recently upgraded to Outlook 2003 and notice that
I could no longer resolve names via the LDAP server. I
get always get a message that there are too many matches
in the Internet Directory.
This does not occur with Outlook 2002 or Outlook
Express. With these two applications, the name is always
resolved in less that 20 seconds. Any ideas?
Try a new mail profile.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual account will be deleted w/out
After searching google.groups...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...