Excel 2010 :: ClearFilter Grayed Out

Jul 5, 2013

Using Excel 2010: After filtering successfully, the ClearFilter is grayed out.

View 1 Replies


ADVERTISEMENT

Excel 2010 :: Insert New Equation Grayed-out

Dec 2, 2012

I put the "Insert new equation" button on my "Quick Access Toolbar" but it is grayed-out, as in, unavailable. The weird thing is, I also have a "Insert Equation" button on the same toolbar, clicking that opens a small menu of ready stored equations and at the bottom there is another "Insert new equation" button, that is also grayed out. However simply clicking the "Insert Equation" icon puts allows me to insert a new equation, as it should be. The same is true for the "Insert Equation" button in the "Insert" tab.

I am working on a new excel file, i.e. it is a .xlsx file with only one sheet. It worked for me before but I did a windows reinstall and now it doesn't.

Also while on that subject in Word 2010 you can put a "Insert Symbol" button on the "Quick Access Toolbar" which, when clicked, opens a small menu of recently used symbols, while its Excel counterpart directly opens the entire Symbol catalog. Any way to put a button on the Excel "Quick Access Toolbar" that behaves like its Word 2010 sibling?

View 4 Replies View Related

Excel 2007 :: Paste Grayed Out When Attempting To Copy Or Cut

Oct 28, 2013

copy or cut then paste - paste grayed out in excel 07 tried several popular fixes from the web without luck.

Tried: the Excel repair and diagnose tool

Tried: uninstall / reinstall Excel program as well

Tried: go into Hikey - user - software - Microsoft - excel - new - 32 binary and tried adding new rule

Tried: Close Excel.2. Go to C:Documents and Settings[userID]Application DataMicrosoftExcel3. Delete the XLB file.4. Open Excel (the XLB file will be recreated - like the normal.dot) ------> This one - I could not find the XLB file - looked everywhere.

Tried: Open excel hit alt-f11 (to get to the VBE) hit ctrl-g (to see the immediate window) type this and hit enter: application .command bars ("cell").reset Then back to excel to test it."

View 3 Replies View Related

Excel 2007 :: Macros Enabled But Record Macro Grayed Out

Apr 14, 2008

I have excel 2007 and I want to record a macro. I have enabled all macros via the Trust Center settings and have even saved the current workbook (created from scratch in 2007) to a macro-enabled version.

But when I click on the 'developer' toolbar, 'record macro' is grayed out.

View 9 Replies View Related

Excel 2007 :: Can't Edit Cell - Unprotected Button On Changes Group Tab Grayed Out?

Jul 28, 2014

I'm trying to change a cell in a 2007 workbook but I'm getting this message:

"the cell or chart that you are trying to change is protected and therefore read only. To modify a protected cell or chart first remove the protection using the unprotect sheet command (review tab, changes group) you may be prompted for a password."

However, the unprotect button on the changes group tab is greyed out (the protect button is available though). The workbook isn't password protected and I'm not being asked for a password. What am I missing?

View 2 Replies View Related

Remove Hyperlink Grayed Out

Oct 8, 2008

I have Excel 2007 and a local copy of worksheet that was previously shared.

There are some fields that refer to broken hyperlinks that I wish to remove, however the "Remove Hyperlink" is grayed out.

Note: The "Pointing Up Hand" appears when mouse cursor is within these fields with broken hyperlinks. I wish this not to occur.

View 2 Replies View Related

Import Data Grayed Out

Aug 6, 2006

This is on the Data- Import External Data menu.

Please how can I enable it to continue my work?

View 7 Replies View Related

Copying Pivot Table To New Sheet - Chart Data Range Grayed Out

Jun 4, 2012

I have a user that uses pivot tables and charts every month to do a report. He wants to copy his charts every month and then just change the month in the data for the pivot table, but not matter what he tries its tied to the previous month and then chart data range in the select data source properties is grayed out. how to get this to work?

View 3 Replies View Related

Excel 2010 :: Getting Outlook Warning (2010) While Sending Email Through Macro

Mar 25, 2014

I am trying to send bulk emails from my excel 2010 - however I am getting a POP UP. find the screen shot in the enclosed word document So every time a new mail is sent from excel we need to press the button allow Is there a way where I can turn off this warning.

View 6 Replies View Related

Excel 2010 :: How To Save Excel File As Cell Reference Using Macro

Mar 5, 2012

I have created a macro in excel 2010 which enable the file to save (extract) data into separate location and name. The vba code for macro is as follows: Question: How can I save this workbook with reference to the value containing in cell B2? (it is named temporary now - as defined in the code)

Sub aaa()
'
' aaa Macro
'

[Code].....

View 1 Replies View Related

Excel 2010 :: Macro To Change Excel Formatted Table Name Dependent On Number Of Loops

Jul 9, 2012

Recorded macro. The hope is to insert a excel formatted table a set number of times. I have found a loop code that references a Cell A1 and repeats that amount of times. So if A1= 10. There should be 10 tables inserted. However on the second time there is a fault with the table name. I need the name to change each time the loop is run. ie Table1, Table2, Table3 etc up until the loop stops (A1 contents).

I am using excel for windows 2010. The macro that i have so far is below.

Sub LoopTest()
Dim n
Dim V
Range("A1").Select
V = ActiveCell.Value

[Code] ........

View 1 Replies View Related

Adjust Macro From Excel 2003 To Excel 2010?

Apr 1, 2014

I am trying to adjust the below macro so that it will work in Excel 2010.

Sub OpenAndProcess()
Dim fs As FileSearch
Dim I As Integer

[Code]....

View 3 Replies View Related

Excel 2010 :: How To Calculate Age

May 1, 2014

keep getting "The formula you typed contains an error".

To calculate a person (or anything else) age you basically subtract his date of birth from today's date. However which date functions to use depends on the amount of precision and the output format you want.

3. If we want his age in years and months, then we can use a formula like this one:
=INT((TODAY()-A1)/365.25) & ” years and ” & INT(MOD((TODAY()-A1)/365.25;1)*12) & ” months”

The output of this formula will be as follows:
40 years and 2 months.

I change A1 to G3 because that is where I the birth date.

View 2 Replies View Related

Excel 2010 :: Import CSV Using VBA

Jul 8, 2014

I'm having problem importing a CSv file into Excel. The CSV file is around 4-5k lines.

The layout is similar to this :

H1, H2, H3, H4, H5, H6
A4, A3, dummy, Dummy, ~,
A4, A3, dummy, "Dummy ,Dummy", ,
A4, A3, dummy, Dummy, +,
A4, A3, dummy, Dummy, -,
A4, A3, dummy, Dummy, "(5 + 4) /4",

Consider that the formula (5 + 4) /4 has a CR and LF between (5+4) and /4

I've tried a few methods to import the files:

Reading the CSV file as a Text File a line at a time but with the CR a LF it get's all messed up

[Code] .....

Tried with Using OLEDB but the Sign + , - and ~ are read a Null

[Code] ....

And Finally tried wit th QueryTable but it does not recognize the Double Quote that precedes the comma so

"Dummy ,Dummy" it's seen as two column values instead of one.

[Code] .....

View 4 Replies View Related

Excel 2010 :: Find The Last Used Row?

Nov 12, 2011

I am trying to use the code that can find the last used row in particular column.

Here is the code in module1

Code:
Function LastRow(rng As Range)
Dim temp, temp1
Dim col As Range
With Application.Caller.Parent
For Each col In rng.Columns
temp = Cells(Rows.Count, rng.Column).End(xlUp).Row
If temp > temp1 Then temp1 = temp
Next col
End With
LastRow = temp1
End Function
and code in the range

Code:
=LastRow(V12:V300)

My problem is, this code was working nicely but now it only shows ###.

PS I use MS office 2010

View 9 Replies View Related

Excel 2010 :: Convert To PDF

Feb 16, 2012

I have just upgraded Excel from 2003 to 2010 and cannot locate where I would convert a spreadsheet to a .pdf document.

View 2 Replies View Related

Excel 2010 :: Sort By Every Other Row?

Jul 11, 2012

I have several long lists (each is 600+) of vocabulary words & definitions and need to alphabetize/sort the words, but need to keep the definitions w/ the words.

A1 = word 1
A2 = def. 1
A3 = word 2
A4 = def. 2
A5 = word 3
A6 = def. 3

Standard sort will alphabetize all rows & the words will be separated from the definitions. I could group rows 1 & 2 together, rows 3 & 4 together, etc. but that's clunky & time-consuming.

I'm using Excel 2010.

View 4 Replies View Related

Excel 2010 :: Changing Last Name First Name To First Name Last Name?

Aug 26, 2012

Is there functionality in Excel 2010 to convert a cell that has last name, first name to first name last name? For instance:

Before: Mouse, MickeyAfter: Mickey Mouse

I'm trying to merge data from 2 sources, and the common data between the two is the name. However, it is formatted differently in each data source.

View 2 Replies View Related

Excel 2010 :: Provide Right Most Value In Row?

Oct 15, 2012

USING EXCEL 2010

I am looking for a formula that will provide the right most value in a row.

View 9 Replies View Related

Excel 2010 :: Next Available Row With Blanks

Nov 28, 2012

I need to get the row number of the next available row , and my column contains many blanks .

Code:

Selection.End(xlDown).Select
Selection.End(xlUp).Select

will not work, nor will

Code:

Blast = WorksheetFunction.CountA(Range("b:b"))

HTML Code:

Excel 2010ABCDE230/09/2012SC12274-1brine 30/9/1231/10/2012FR12275-1brine 1/10/1241/10/2012BQ12275-
1yc12275-159/10/2012FR12283-1brine 9/10/1269/10/2012SC12283-1yc12283-1710/10/2012BQ12284-
1brine 10/10/12815/10/2012brine 15/10/12916/10/2012FR12290-11016/10/2012BQ12290-11122/10/2012SC12296-

[Code]....

In column b the next available row would be 16 ( the first 30/10/2012 row ), if I use the counta system i would get 7, and the xldown / xlup system would need to depend on where I start, which is what I need to determine

When I veiw this all I get is an immensely huge list of HMTL.

View 5 Replies View Related

Excel 2010 :: Import CSV Using VBA?

Jul 8, 2014

I'm having problem importing a CSv file into Excel. The CSV file is around 4-5k lines.

The layout is similar to this :

H1, H2, H3, H4, H5, H6
A4, A3, dummy, Dummy, ~,
A4, A3, dummy, "Dummy ,Dummy", ,

[Code]....

View 4 Replies View Related

Excel 2010 :: Refresh The Ribbon?

Feb 15, 2013

I have an excel tool I am adapting to 2010 from 2003. It imports another tool which has been created elsewhere in my company and it is protected so I cannot alter it. This tool that I cannot change creates its own custom toolbar the "old fashioned" way so it dumps into the add-in tab on the ribbon. My tool opens this corporate tool and changes some items on the toolbar (enters values in a text box) and then imports data from it. However in run-time the custom toolbar never appears. Is there a way to refresh the ribbon in run-time after opening the file so I can then access the toolbar items?

View 1 Replies View Related

Excel 2010 :: Using Multiple Comboboxes

Jul 23, 2014

I am trying to develope a userform in EXCEL 2010 that has a couple of comboboxes that pulls data from a specific worksheet. The first combobox is initialized with data from column "A" of the worksheet, which I can get to work perfectly. But what I am having trouble with is the second combobox, the data that needs to populate combobox2 is dependent on combobox1 results which are the column headings ("B" thru "E"). What I want to do is search row 2 find the result from combobox1 and populate combobox2 with the data below that result. Below is my data that I am working from.

TableData.jpg

View 9 Replies View Related

Excel 2010 :: DAX Calculate With Two Filters

Dec 24, 2013

Using Excel 2010

How can I use 2 filters in DAX Calculate?

I tried

MyCalc:=CALCULATE([MyMeasure], Filter(Tbl,Tbl[Field] && Tbl2,Tbl2[Field2])) It works with 1 Filter : MyCalc:=CALCULATE([MyMeasure], Filter(Tbl,Tbl[Field])) Just falls down when I add the second filter.

View 7 Replies View Related

Excel 2010 :: Show Certain Image For Certain Value?

Mar 28, 2014

I have this excel that look like this:

A1, B1, C1 contains an image with the numer 1, 2 and 3.

D1 is a cell where you can put only the number 1 2 and 3 (alert if you insert something else)

E1 have to contain the number in the D1 written with letters (I did this with the formula: =IF(D1=1;"One";IF(D1=2;"Two";IF(D1=3;"Three";"Wrong Imput")))

F1 have to contain the image from the A1, B1, C1 corresponding to the number in D1

Now, how do I do this ? I read an article here, on this forum, about doing this. I know how to copy an image from A1, B1, C1 in F1, but I don't know how to make a formula to do this.

To copy an image from A1, B1, C1 I do this:

- I copy the cell (F1)

- I hold Shift key

- I go to Start -> Paste -> Click the little arrow -> Last option (Translated from my language I think It's Linked Image) -> I switch the formula in that cell to =A1 or =B1 or =C1 -> The image appears.

I really want to know how to do that thing. I saw that you can not use an IF formula in the linked image cell so I need another option.

By the way, I attached the excel. If you will open it, go to Item2 Spreadsheet. I'm using Excel 2010 now.

View 2 Replies View Related

Excel 2010 :: Count If Not Operating

Jul 22, 2014

As per the attached sheet Count If is not operating.

Effective Reading Capability
Effective Reading Capability
Effecting Writing Capability
Application of Basic Mathematics 0.4
Effective Listening Skills 0.3
Effective Speaking Capability 0.3
Attitude to Cleanliness 0.3
Idea Generation & Creative thinking 0.1
Decision Making Skills ( Upto the mandate)0.2

[code].....

here If I say Countif(B4:B20, >=0.5) But it shows Zero.

View 6 Replies View Related

Excel 2010 :: Pull Value From One Workbook Into Another

Aug 6, 2014

Using Excel 2010. I have 2 worksheets, saved in same folder (if that matters).

Worksheet 1=Master_List.xlsx
Column1
Column2
Column3
Column4
PartNumber

1002
Sony
Playstation
4D
W74859

Worksheet 2=Sample_List.xlsx
Doesn't Matter
Doesn't Matter
Doesn't Matter
Doesn't Matter
Doesn't Matter
Column1
Column2
Column3
PartNumber

Doesn't Matter
Doesn't Matter
Doesn't Matter
Doesn't Matter
Doesn't Matter
1002
Sony
Playstation

Basically, I'm looking to populate the blank cells in the PartNumber column (Sample_List) by looking at the data in Column1, Column2, Column3 then going to the Master_List, matching up Column1, Column2, Column3. The PartNumber value in the row with the matching values would then be copied to the Sample_List.

View 4 Replies View Related

Excel 2010 :: Cannot Subtract With Decimal

Dec 6, 2013

[URL]

I tried the following formula on excel 2010:

=ROUND(2.01,2)-ROUND(2,2)-ROUND(0.01,2) but still I am getting -2.13371E-16 as a result.

How can I make it return 0 instead? I am trying to compare the above formula with 0: =2.01-2-.01<0. it returns TRUE, which should be FALSE.

View 3 Replies View Related

Excel 2010 :: Setting Row Height

Jul 1, 2014

I am running Excel 2010. On a sheet that I have previously used many times, I select all, and set row height to 30. In the past, that has made the sheet fit nicely on one page. Nothing has been changed in the content or number of rows, but all of a sudden the result leaves me with a sheet that takes more than one page to print. It is almost like the number entered is being defined by some new unit of measurement.

View 2 Replies View Related

Excel 2010 :: File Different On Two Computers

Jul 7, 2014

I currently have a worksheet opened on excel 2010 using windows XP. When I open the exact same file on another computer using excel 2010 using windows 7. The spacing and formatting is different.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved