Stack Overflow
Stack Overflow

Questions tagged [excel-2013]

The Excel-2013 tag is used for referencing the Excel Version 2013 spreadsheet application from Microsoft. If your question is about VBA then also tag it VBA. If it is about an Excel formula then tag it Excel-Formula.

Excel 2013 is the 15th version of Microsoft's commercial spreadsheet program. Microsoft has significantly enhanced the charting and Business Intelligence capabilities in this new release.

This tag is used for questions specific to the 2013 version of the program. However, it is usually used in tandem with other tags, to let SO users know what your question is about. If your question is about VBA then also tag it . If it is about an Excel formula, tag it . Questions about addins for Excel 2013 should be tagged .

Links:

1745 questions
12
votes
6 answers

How can I stop Excel processes from running in the background after a PowerShell script?

No matter what I try, Excel 2013 continues to run in the background on Windows 10 no matter what commands I throw at the end of my PowerShell script. I've tried adding all suggestions I've found to the end of my script and the only Excel object I…
mtb2434
  • 147
  • 1
  • 2
  • 7
12
votes
3 answers

Remove Duplicates from range of cells in excel vba

I'm trying to remove duplicates in excel 2013 VBA. but I'm getting error "object does not support this property or method". The problem is I don't have static range to select. I want remove duplicates from the column heaader 'abcd'.…
Hideandseek
  • 271
  • 1
  • 4
  • 17
11
votes
3 answers

excel active x control button is not working suddenly

I'm working with excel macro-enabled files, Today I just found out the button i made was not working-cannot be click- which was working yesterday. And digging up the matter, I found out that other Activce X controls is not working also, and I cannot…
user2958279
  • 570
  • 1
  • 5
  • 11
11
votes
5 answers

Excel ran out of resources while attempting to calculate one or more formulas

I have a workbook to do 'smart'-graphs on my expenses. It's been running for a year and there are now a lot of graphs and expenses. Excel now throws an out-of-resources error whenever I change anything or open the workbook. Thing is, I have lots of…
flacnut
  • 1,030
  • 4
  • 11
  • 21
10
votes
1 answer

Calculating Standard Deviation with If in Excel

I have a dataset with two columns. One label and one number. Using sumif and countif, I managed to calculate the average of each label in groups. Now, I am trying to do the same with Standard Deviation but I have a…
Tasos
  • 7,325
  • 18
  • 83
  • 176
10
votes
4 answers

Using VBA to insert and keep images in file - Excel 2013

I'm working on a macro for a friend of mine who needs to import a set of images in an excel document and later use this document on other computers. The problem I encountered is that when opening this document on a different computer, all the images…
FlyingM
  • 217
  • 2
  • 7
  • 17
9
votes
5 answers

Add comments to cells using VBA

Is there a way to activate a comment on a cell by hovering over it? I have a range of cells that I would like to pull respective comments from another sheet when hovered over each individual cell. The hover event would pull the comments from their…
studentofarkad
  • 155
  • 1
  • 1
  • 8
9
votes
5 answers

How to add a Formula To Cell using VBA

I am attempting to write some VBA which will add header text to 3 cells then fill a formula all the way down to the last row. I have written the below, which writes the headers no problems, but when it get's to my first .Formula it throws a…
BellHopByDayAmetuerCoderByNigh
  • 1,107
  • 4
  • 21
  • 41
9
votes
4 answers

Find the last not empty row in a range of cells holding a formula

How can I find the last row in a range of cells that hold a formula, where the result of the formula is an actual value and not empty? Say in a simplified way that the range of cells ("E1:E10") hold a formula referring to cells A1 through A10 as…
Pascale
  • 135
  • 2
  • 7
9
votes
3 answers

Can large datasets be used with Excel 2013?

I've been reading in several places that Excel 2013 (64-bit) has the ability to open larger datasets, with more rows than before. Yet, my limits seem to be right at where they were with 2010. I get the same old error about having more than a million…
Chris J. Vargo
  • 2,266
  • 7
  • 28
  • 43
8
votes
2 answers

Find all items on list B that are not on list A, Excel.

I have list A with 259 items and list B with 626 items. There is some overlap between the list, so I want to find all items on list B, which are not on list A. I've been trying to find some info on how to do it in Excel on the Net, but I cant figure…
Tom Smith
  • 125
  • 1
  • 1
  • 5
8
votes
2 answers

Conditional Formatting of maximum value in each row of many

I have a spreadsheet with 250+ rows of data and need to find the largest value in each row. I tried to use Conditional Formatting, however I need the same rule for each row so can't highlight all the data, and trying to copy and paste it would be…
Eastern Computers
  • 85
  • 1
  • 1
  • 4
8
votes
3 answers

How do I concatenate cell values and text together using Excel VBA?

I have a repetitive task I'd like to automate instead of using the =Concatenate function all the time. Here's my code so far: Cells(2, 5).Value = Cells(2, 1).Value&" - "&Cells(2, 2).Value Unfortunately this results in the "Compile error: Expected:…
xxxRxxx
  • 357
  • 2
  • 7
  • 17
8
votes
12 answers

No Add-In Tab Though Add-In is Loaded and Working

I wrote an Excel VBA add-in over ten years ago, which uses the old Commandbars to put a menu in Excel's Tools menu (in Excel 2003 and earlier) or in Excel's Add-Ins tab (in Excel 2007 and later). I've never had a problem with the menu appearing, in…
Greg Lovern
  • 958
  • 4
  • 18
  • 36
8
votes
2 answers

Append & prepend string to existing rows

I have a table of numbers: 1 2 3 4 5 6 7 . . . What i would like to get: *1* *2* *3* *4* *5* *6* *7* . . . I have written a formula, but i dont know how to apply this function to the existing table. I keep getting some kind of reference error.…
Biker John
  • 2,621
  • 10
  • 33
  • 52
1
2
3
…
99 100