|
Fixed time and date
I need cell "H1" to display a fixed time and date on open of the workbook.
Then when workbook is saved, this date and time remains static. Can this be
done? ...
|
9 |
28.09.2006 07:01:54 |
|
|
List box problem
I have inserted a listbox in a w/book,this w/book has no macros.Whenever I am
opening this w/book a message box 'this w/book contains macros
enable,disable'
is poping up.As I know my w/book has no macros,I opted for 'disable
macros'.But after that I am unable to select an item from the list in my
listbox.Cusor becoming cross arrows(4arrows) style.How to resolve this?...
|
2 |
28.09.2006 05:34:02 |
|
|
disable user running macro from Tools > Macro
Help please . . .
I have a macro that I've assigned to a button on a worksheet. I've
protected the VBA code and I only want the users to be able to run the
macro from my button.
How do I disable the user from running the macro from Tools > Macro?
TIA
Steve...
|
5 |
28.09.2006 05:28:01 |
|
|
Save funciton no longer working after latest download
After receiving the latest download for Office 2007 I have lost the save as
function in my Office Programs. It worked fine before the download. This is
not limited to just Excel....
|
1 |
28.09.2006 04:26:02 |
|
|
inconsistent error message
When working on my spreadsheets I enter a simple formula into a cell, e.g.
=345+25, hit enter, and the Smart Tag appears showing the error that the cell
is not protected. I then must click and tell it to ignore the error and this
continues until I'm finished with all my entry.
I go to the next spreadsheet and enter an identical formula: =345+25, hit
enter and no error messages appear. D...
|
2 |
28.09.2006 02:34:32 |
|
|
I can't send attachment from excel by email
I can't send attachment from excel by email.
There is an error message - General mail failure. Quit Microsoft Office
Excel, restart the mail system, and try again.
Thanks
...
|
1 |
28.09.2006 02:23:01 |
|
|
update the cell with formatting
Hello,
I am in a situation where all my cells on one worksheet(say 2) are
updated according to the cells in other worksheet (say 1).
Though all the formulas in 2 are calculated with the values in 1. I
also need to update it based ont he formatting of the cell in 1.
If cell in 1 has a red fill in color, the corresponding cell in 2
should also get updated to red fill-in color.
Is ther...
|
2 |
28.09.2006 02:09:46 |
|
|
text in data area on pivot table
I want to generate an event calandar trigger by a database whit text
in the data area.
Pivot table is nice to display, sorting, filtering and calculate, but i
need to put text field on the data area instead of number.
The only other way that i see is to create a formula using match,
vlokup, hlookup, with header and row
Is there some other way to create a dynamic table with row
and co...
|
1 |
28.09.2006 02:03:02 |
|
|
INDIRECT filldown problem
Hope I can get a bit of help on this, we have about 2000 rows and 50 or
so cells in our row that have formulas that have "(INDIRECT(T$1&
"$AB6") in them, as an example. The problem is we'd like to
filldown but the "$AB6" part of it will not change to "$AB7",
"$AB8" as it is pulled down. We need to keep the " " because
it has to reference a cell. Is there a way to do this? I'll example
wh...
|
3 |
28.09.2006 01:44:29 |
|
|
How do I assign a numeric value to text? IE cell = yes then 1
I am trying to create a simple list in a cell: YES or NO. Then I want to
sum the row of YES or NO's. If I can assign a value of 1 to YES and 0 to NO
I can do the math. Not sure how to assign a numeric value to a short list of
text in a cell to enable this math operation....
|
8 |
28.09.2006 01:01:02 |
|
|
Macro aid please
I have the following macro doing a filldown and it works perfectly.
Dim a As Long
a = Range("B" & Rows.Count).End(xlUp).row
Range("C6:BQ" & a).FillDown
End Sub
I then have a second sheet I would like to at the same time, autofill
down the exact number of lines the first sheet pulls down, am hoping to
have one macro pull both pages down, based on the above macro. How
would I do this, if its...
|
4 |
28.09.2006 00:58:10 |
|
|
My Excel Chart No Longer Auto Updates
I have run into a problem where my excel charts no longer autoupdate.
I am not sure if it is because of macros I have written, but I doubt
it. When I update a cell from, say, 20 to 30, the chart does not
automatically update. The only way to see changes in the chart is to
click on source options and then have it pick up the source data line
again. Even though the source data line is alread...
|
2 |
27.09.2006 23:56:02 |
|
|
colum width
Format column to be x characters wide....
|
6 |
27.09.2006 23:50:28 |
|
|
Recover email sent from excel sheet via outlook/didn't arrive
I was working on an Excel sheet and clicked on an email address I had typed
in there... an Outlook window appeared, and I typed, and I thought sent, a
message. I even clicked the save icon because the letter was lengthy... not
too surprisingly, it was not sent... I thought it was enough to have Outlook
open but realize I should have logged in and not mailed from my Excel sheet-
is there ...
|
1 |
27.09.2006 22:43:02 |
|
|
My pivot table does not accept select non-adjacent columns?
My pivot table does not accept select non-adjacent columns? Also, I am
wondering if I can create a simple chart with the data I have - breaking the
data into groups to create more than one chart. I have lot of columns with
ratings and yes/no answers. I have copied sample of the data. Help would be
appreciated.
Ed Level # of Online Crses Tech Ability Before Crse Tech Ability
Af...
|
1 |
27.09.2006 22:42:01 |
|
|
Can I save excel files as web connected files
I am using QuickBook accounting software. I have over 300 sales orders need
to create, then generate to invoice per day. Based on the instruction of
QuickBook, I can import web connected files to QB so that I do not need to
key in sales order one by one. Can I make an excel sheet, saved as web page
and import to the QB...
|
1 |
27.09.2006 22:34:02 |
|
|
How to test a cell for the strikethrough effect?
What formula, if any, would return, say, "true" or "false", for the presence
of the strikethrough effect on text in a given cell?...
|
3 |
27.09.2006 22:13:24 |
|
|
The "networkdays" function doesn't work even with helpfile example
my excel help identifies this function, but the actual use of it returns the
?name error.
Furthermore, it does give me the dialogue box for the function to help me
fill in the data, but doesn't show any valid value and errors on completion
of the dialogue box.
...
|
4 |
27.09.2006 22:06:03 |
|
|
Chart update using button
Hi
How do i update chart using Command Button and VBA
I have D10:D500 where i need to plot chart on those values I have ""
this on D10:D500 if there is no data on other column E10:E500 , problem
is its assuming that its 0 If there is no value on the D column cell
and my chart comes back to Zero and a stright line.
Is there any way to update chart using command button if only there i...
|
1 |
27.09.2006 22:01:57 |
|
|
Cell Format Issue
I get unexpected results when date formatting a worksheet cell in a MS Excel
spreadsheet - in other words it looks like a calculation is trying to take
place such that entering 1220 in the cell returns a date of 5/4/1903 and
entering 12202006 0r 122006 returns a negative date displayed as ########. I
have not experienced something like that before – and I use MS Excel way too
much!
...
|
8 |
27.09.2006 21:57:28 |
|
|
Excel data compar
Hi everyone,
I have two Excel spreadsheets. On one of them i have two collumns that
contains a range of number. Like in cell A1 there is the number 2470000
and in the cell B1 there is 2470099. On the second spreadsheet, there
is 2470000 in the cell A1 and 2479999 in cell B1. What i need to do is
to check if the range of number i have on the first spreadsheet is
included in the range of th...
|
2 |
27.09.2006 21:47:01 |
|
|
When Inserting Rows in Excel, not all formulas copy to new row?
How do I get all of the formulas in the rows above and below the row that I
am inserting to automatically copy to the inserted row?...
|
3 |
27.09.2006 21:35:55 |
|
|
How can Excel solve this?
I have a bunch of numbers, lets say A, B, C, D. Each number is made up of a
combination of other numbers, lets say 1, 2, 5 make up A, 3, 7, 8, 9 make up
B and so on.
Is there any way I can get an output saying A is made up 1, 2 and 5 in
Excel? I think it could be done using Solver, no?...
|
5 |
27.09.2006 21:26:03 |
|
|
When paste special links the file name gives error
All
When Paste Special links the option of Bitmap, etc is given instead of
linking the cell. Also cannot just do = and select the other workbook and
select a cell.
...
|
3 |
27.09.2006 21:05:30 |
|
|
Consecutive page numbers on worksheets in Excel
I have an Excel spreadsheet that has 3 separate worksheets in it.
The documents will all be printed together as one large document and I would
like consecutive page numbering throughout the document. So far, all I can
get is page 1-3 of the first worksheet, page 1-4 of the second, etc.
Any advice? Can this be done?...
|
4 |
27.09.2006 20:59:17 |