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
0
votes
1 answer

Setting Up A Potential Excel Macro

I'm not even sure if this is something you would use a macro to do the second question. I have a spreadsheet of a list of cards in a card game I play on the PC. So this leads to two questions. 1) Column E is for legendaries. If the column value = 1,…
Whitechapel
  • 119
  • 3
0
votes
2 answers

How to graph values measured at different intervals?

I have a table of values measured in time, but the time intervals between consecutive values are not the same. It looks like this: time (in days) value 179.948 9.89 230.869 10.1 236.956 10.11 I want to graph this in…
Garnagar
  • 71
  • 6
0
votes
1 answer

Refresh Connections and Pivots in Excel 2007, 2010 and 2013

So I've been running this VBA code in Excel 2007 without any problems: Sub Button_Click() For Each objConnection In ThisWorkbook.Connections objConnection.Refresh Next Dim Sheet As Worksheet, Pivot As PivotTable For Each Sheet…
Zifendale
  • 140
  • 2
  • 12
0
votes
4 answers

How to add cells with mix of 6 to 8 decimal places together

Because of floating point values, I cannot add a string of cells that contain values such as: 0.08178502 0.09262585 0.13261762 0.13016377 0.12302067 0.1136332 0.12176183 0.11430552 0.09971409 0.125285 Even if I try adding the first two…
Underdog
  • 9
  • 3
0
votes
1 answer

Decoupling Groupings of Fields in different PivotTables from same data

Is it possible to decouple a field so that it is grouped in two different ways for two different pivot tables within the same workbook? For example, time might need to be in hours on one sheet and in minutes on another.
Max Power
  • 167
  • 1
  • 2
  • 12
0
votes
1 answer

excel 2013 interior.color "#Value!" error

When i try to change color of a cell using a function like this: Function abcd() Worksheets("Sheet1").Cells(1, 1).Interior.ColorIndex = 3 End Function by calling the function from a cell "=abcd()" it returns a "#Value!" error. but if i use a…
Reza
  • 3
  • 3
0
votes
1 answer

floating vertical alignment in excel 2013 merged cell

I have a merged cell that spans about 700-800 rows. Is there a way to make the value of the cell float in the visible range of the sheet? I really hate the limitation of the vertical alignment being limited to top, center and bottom. Surely there is…
Richard Molby
  • 11
  • 1
0
votes
1 answer

Excel 2013 Format Hyperlinks

I'm working with Excel 2013. And I need to style ALL of the Hyperlinks in my workbook. In Word, I can just select - for example Heading 1 - and modify it. This makes all Heading 1 texts same. But I couldn't do it with Excel 2013. How to format all…
Degauser
  • 120
  • 1
  • 2
  • 9
0
votes
1 answer

Where is the change case button in Excel 2013

I want to change the case of a column in Excel but I can't find the button I was used to click in Excel 2010. I know I can change the case creating a temp column and then creating a formula. But I want to find that button. So, where is the change…
Daniel Bonetti
  • 2,306
  • 2
  • 24
  • 33
0
votes
0 answers

Excel vba code needs to compile to execute

I create a excel file with vba code in excel 2013 (64 bit version). When I copied the excel file in to another machine which has excel 2013 (32 bit) I have to go to the vide code and compile the code to execute the vba code. I am simply doing change…
udaya726
  • 1,010
  • 6
  • 21
  • 41
0
votes
1 answer

How to skip user chosen dates in MS Excel autofill?

I am given a start date that I enter into a cell. Then I do a fill down 100 days. It then sequentially will fill in all the days. There is a setting to exclude weekends which I applied. So now it is the next 100 weekdays. The problem I have is…
billmann
  • 57
  • 8
0
votes
2 answers

Restrict Excel Cell Input Value

I have Excel Sheet. I have locked and Protect other cells. I have 2 cells that required user input and both are currency Datatype. If I input text in those cells it messes up calculation so I would like to format those cells in a way that if…
Keyur Shah
  • 27
  • 1
  • 1
  • 6
0
votes
1 answer

redefining a 2 dimensional array

I'm kind of struggling of redefining an array. I have simplified my code, see below: Sub Knop1_Klikken() 'all the cells are defined in an array Dim col, i As Integer, defrow As Long Dim notAct(1 To 20, 1 To 43) As Integer For col = 2 To 4 For…
Tarik
  • 77
  • 1
  • 1
  • 11
0
votes
1 answer

defining lots of different variables

Is there a faster way to define the following variables. notAct is the name, after the name comes the cells positions. The "b" is for the column and the number refers to the row. The value is 0. Very single cell has to be defined so that I can use…
Tarik
  • 77
  • 1
  • 1
  • 11
0
votes
1 answer

Find & Replace Textboxes and Macros

Is there a way to find and replace embedded macros in textboxes? Example. I create a lot of textboxes and I assign them macro's say RunBox.1 WalkBox.1 SleepBox.1 now lets say I copy those textboxes. It will have the macro's I assigned in the box…
Michael Downey
  • 687
  • 3
  • 13
  • 42
1 2 3
…
99 100