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
3
votes
2 answers

Excel VBA trying to edit visibility of shapes inside a group

I have create a project in excel 2013 that shows and hides a large list of shapes (network icons and text boxes) based on the data in the cells at the top of the sheet. My goal was to create a GUI for me to enter network information and as I enter…
Legenis
  • 71
  • 1
  • 6
3
votes
1 answer

VBA Run-time error 91

I assigned a macro to a shape, but I'm receiving a Run-time error '91' Object variable or With block variable not set. But, when I run the Macro from the Developer tab, it works. The "ActiveChart.Axes" line is where the error is coming from. I'm new…
kat2000
  • 31
  • 1
3
votes
2 answers

Excel VB Code to Set Filter to a range of Options

I currently have a Pivot Table that pulls its data from a SharePoint site. With this Pivot table I want to use a Button to set the Filter to a certain date range. I used this site to get the filter to change the Filter value to a certain date, code…
Emmerson
  • 43
  • 5
3
votes
2 answers

Range("CustomTable").SpecialCells(xlCellTypeVisible).Delete now fails. Run-time error '1004'

was wondering if anyone noticed a change in behaviour of the following or similar code: .Range("CustomTable").SpecialCells(xlCellTypeVisible).EntireRow.Delete I use it to delete filtered range on a ListObjects table in excel 2013 and until about…
Raugmor
  • 566
  • 5
  • 12
3
votes
1 answer

Command Button not working

I have an Excel 2010 spreadsheet with VBA code. When I try using it in Excel 2013 some strange stuff happens: The Command Buttons on the existing worksheets stopped working. The VBA code associated to them does not run. Not even an error message…
lamcro
  • 6,069
  • 18
  • 57
  • 70
3
votes
1 answer

Password protecting multiple files in a directory

I have a directory containing 50 .xlsx files. I need to send these to someone and because of their work environment restrictions I am unable to use Winzip. I have previously password protected each individual .xlsx file manually but was wondering if…
user983988
3
votes
2 answers

How to add a filter & sort button in cell?

How can I insert the filter and sort button in the cell as in the picture?
Skyler Cheah
  • 61
  • 1
  • 2
  • 5
3
votes
5 answers

Add radial lines to radar chart

I'm using Office 2013 Excel and making a radar chart. By default the concentric rings are visible, but I want spokes or radial lines from the center to each category on the outside. I can't find out how to do this.
yamori
  • 1,213
  • 4
  • 14
  • 27
3
votes
4 answers

Excel links to JIRA issues forcing re-authentication

Situation Attempting to launch a JIRA issue hyperlink from Excel 2013 drives the user to a login page for JIRA which is unexpected as the user has an active login session. Example link format -->…
Taliesin
  • 389
  • 1
  • 12
3
votes
0 answers

PivotCaches - Generate an error "created in a later version of Excel"

This stupid issue is seriously driving me mad, and I haven't found a way to fix this yet... I have Excel 2010 at work, and Excel 2013 at home. I worked once home and created a few Pivot Tables, and discover at work that error message : So…
R3uK
  • 14,417
  • 7
  • 43
  • 77
3
votes
1 answer

MS Excel 2013 linked data formula reverts to value #REF despite linked values not changing

I am currently working on an MS Excel 2013 spreadsheet (p:\master.xlsx) where some cells contain values that are directly linked from other MS Excel 2013 spreadsheets (p:\path1\feeder1.xlsx, p:\path1\feeder2.xlsx, etc). What I am finding…
Courtenay L
  • 55
  • 8
3
votes
2 answers

Add a space after colored text

I'm Using Microsoft Excel 2013. I have a lot of data that I need to separate in Excel that is in a single cell. The "Text to Columns" feature works great except for one snag. In a single cell, I have First Name, Last Name & Email address. The last…
Onyoursix
  • 109
  • 9
3
votes
1 answer

How can I count only unique occurrences of a value from table using multiple criteria?

I am trying to calculate the percent of users for each role (admin, mod, general user, etc.) who have logged in over a specified timeframe (1 month, 3 months, 6 months, 1 year). Editing the data table that I'm pulling from is not an option as this…
Cecil
  • 31
  • 3
3
votes
3 answers

How to create a counter inside an event?

In Cell A1, I have formula that recalculates automatically every one to two seconds. When this cell recalculate, the old values from A1 is copied to cell B1. Every time it recalculates, I just want to get a running total. So far, what works is when…
B Cheung
  • 31
  • 1
3
votes
2 answers

Why do I need a space before the '^' operator in VBA for Excel 2013 or it will produce a compile time error "Expected list or separator"

If I type for example Sqr(a ^ 2 + b ^ 2) there is no error. But when I type Sqr(a ^ 2 + b^ 2) it produces a compile error which I do not understand: What is the function of ^ in VBA7 as opposed to _^ (underscore to show space) which denotes…
John Alexiou
  • 28,472
  • 11
  • 77
  • 133
1 2 3
…
99 100