|
|
Excel Files Open Read-Only by
Don Brownlee
I'm operating Excel 2007 under WinXP in a corporate environment. My PCs were
recently rebuilt by my corporate IT department. Now, whenever I open an Excel...
|
May 11th, 2009 03:43 PM
by Bob I
|
5 |
291 |
|
|
Excel color pallet rearranging? by
Russ Blumenthal[_2_]
I have a workstation with office 2003. In excel, i color some of the cells
with a color (lets say a blue in the bottom left on the drop down), when I
send...
|
|
0 |
154 |
|
|
Excel color pallet rearranging? by
Russ Blumenthal[_2_]
I have a workstation with office 2003. In excel, i color some of the cells
with a color (lets say a blue in the bottom left on the drop down), when I
send...
|
|
0 |
109 |
|
|
Count formula help? by
John
I need to count the numbers of columns from A3:T3 which have any value
entered in the cell. I also in another cell need to count the non blank cells
but...
|
May 11th, 2009 03:25 PM
by John
|
3 |
90 |
|
|
Corrupted Track Changes in Excel 2007 by
Auntie
I have excel workbooks created in Excel 2003 that I exchange with others,
some of whom have Excel 2007. With some (but not all) of those users, the
track...
|
May 11th, 2009 03:00 PM
by Auntie
|
0 |
103 |
|
|
|
|
6 |
201 |
|
|
|
|
0 |
111 |
|
|
|
|
4 |
111 |
|
|
|
|
3 |
107 |
|
|
|
|
1 |
132 |
|
|
Counting Dates by
Dilly
Column A has a a list of letters (a,b or c) and Column B has a list of random
dates. How do i get a formula that will count all letters of "a" that have a...
|
|
1 |
87 |
|
|
How do i create a diary template in XL by
Ashuruff Hamsa
How do i create a diary template in XL, where i can enter (apart from normal
scribbles) every day income & expenses. The sum of these should appear at
the...
|
|
1 |
101 |
|
|
Continue equation by
mparker
I have an equation average equation on sheet 3 but the data is on sheet 1.
=AVERAGE(IF(paste_data!CL2:CL2000=1,paste_data!B2:B2000))
I want to continue on...
|
May 11th, 2009 12:50 PM
by joel
|
1 |
86 |
|
|
Error Editing an MS Query in Excel by
Chrisg
I get an error when opening an MS Query in Excel "Query cannot be edited by
Query Wizard". If you click O.K all you can do is view and edit the SQL...
|
May 11th, 2009 12:48 PM
by joel
|
1 |
107 |
|
|
VBA does not work by
Frank Situmorang[_3_]
Helo,
Please help me, when I run this code, there is no error message, it opens
the worksheet, but it does not copy the data from the source range.
This is...
|
|
1 |
110 |
|
|
Broken links but they're not by
Andy
When i open a .xls I chose to update values and get an error that the links
cannot be updated. It only looks at two different files and when I go to edit...
|
May 11th, 2009 09:26 AM
by Andy
|
2 |
102 |
|
|
Nesting conditions together. by
Ivan Koh[_2_]
Hi all,
Another question on excel, how do i nest conditions together for AND, OR and
NOT.
So far, what i have is
=IF (OR('A'!A1=X,'A'!A1=Y),'A'!B1,"")...
|
|
4 |
103 |
|
|
|
|
4 |
130 |
|
|
|
|
1 |
118 |
|
|
|
May 11th, 2009 02:58 AM
by Robin
|
2 |
87 |