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

Excel break long lines when importing csv file

When I open a csv file in excel, it break up the lines longer than 32760 characters, put the rest on the next line, and delete at least 2 characters in the process. There is no special characters at the break up place. Is it a normal behaviour?…
Liad
  • 340
  • 4
  • 15
3
votes
1 answer

How to get Range (Print Area) from Excel?

I made an Excel Add In, that has to export the print area as an image. It works fine, if I set the print area manually from the program ("Excel.Range range = sheet.Range["A1", "E5"]"), but I need to set the print area in Excel and export that area…
Adam Miklosi
  • 764
  • 5
  • 18
  • 28
3
votes
1 answer

How to combine subtotal and sumif with a range of criteria

I'm trying to create a formula to combine a SUMIF (using a range of criteria) and a subtotal. The SUMIF statement: =SUMPRODUCT(SUMIF(E:E,O2:O21,G:G)) And where I've gotten on making that SUMIF…
NotAnExpert
  • 33
  • 1
  • 1
  • 7
3
votes
1 answer

Merge Every 3 Rows In Row 1

I am trying to merge every 3 cells of row 1 (starting with B1, and the last cell to be merged is FY - meaning FW, FX & FY should be merged.). I have used this to merge every 3 rows going down a column, but how would I alter this to go across row…
SmallFries BigGuys
  • 171
  • 4
  • 18
3
votes
1 answer

How to use wildcard in Cubevalue formula in Excel?

I am trying to get the values with wildcard in Cubevalue formula(below) in excel. I am not finding any solution. =CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of Bookings_Net]","[Dashboard_Data].[Level_1].[Karnataka_India]") I am trying to…
Punith GP
  • 690
  • 4
  • 11
  • 33
3
votes
1 answer

how to draw spline graph in excel 2013

I have checked spline graph in excel-2013 chart. But MS-Excel does not provide spline chart support. Does anyone know a workaround solution to render spline chart without using add-on and algorithm to generate points?
Bharathi
  • 1,288
  • 2
  • 14
  • 40
3
votes
2 answers

python xlsxwriter - wrong category axis in column chart in Excel 2013

I'm using xlsxwriter to generate a chart. I'm trying to use texts for the category axis, it works in almost every excel version (2007, 2010). But not in excel 2013, and not in Microsoft Excel Online (which seems to be like excel 2013). The…
user3599803
  • 6,435
  • 17
  • 69
  • 130
3
votes
2 answers

VB6 extracts in Excel 2013

I have a few applications writting in legacy VB6 that have extract code built into to create EXCEL extracts. We are moving from Excel 2007 to Excel 2013 and I've run into some issues. I'm running Windows 10. In 2007, this is my declarations and Set…
BobSki
  • 1,531
  • 2
  • 25
  • 61
3
votes
1 answer

Adding a row to an Excel table using VBA without enabling total row

I have a table (called PortDistances) showing distances between pairs of ports. I've got it set to not show a totals row, because it's simply not relevant to the data in it. I also have a UserForm to add a line of data to the end of the table, using…
Andrew Perry
  • 743
  • 2
  • 11
  • 32
3
votes
2 answers

How to change Excel 2013 Template Miniature

Is there a simple way to change / replace the automatically generated Template Miniature with a different image.
Jesper Storm
  • 31
  • 3
3
votes
1 answer

Conditional Formatting with increasing colors

I have a list of repeating table names: Table1 Table1 ... Table2 ... Table99 I was wondering if there was anyway to use Excel conditional formatting to highlight each different table name a different color using some sort of increment. So table1…
Mike
  • 5,918
  • 9
  • 57
  • 94
3
votes
3 answers

Compare Two Worksheets and Highlight Difference

I have two worksheets that contain the same data points. I need to compare Sheet1 (valid data) to Sheet2 and see what was altered on Sheet2 by changing cell color to red. I tried this macro, but it painted everything, not just the differing cells.…
J-Nasty
  • 47
  • 1
  • 5
3
votes
1 answer

EXCEL 2013 : set the name of variable from value of cells

I have set the name P1A_FO_DESIGN on a cell A1 that countains the value 5.12 I have set another cell C10 with this value: =("="&A10&"_"&B10&"_"&C8) A10 contains P1A B10 contains FO C8 contains DESIGN the value of C10 is =P1A_FO_DESIGN but I would…
yakitori
  • 37
  • 4
3
votes
3 answers

Configure job number to incorporate prefix, year, month and next sequential number

I am using Excel 2013 (64 bit). I'm currently working on a Userform which is used to log incidents. However I have been unable to work out in VBA how to come up with the code that will result in the next available number from the previous row…
TheShyButterfly
  • 121
  • 10
3
votes
1 answer

How to import data into Excel from SSAS Tabular model as Table?

I'm trying to import data from SSAS Tabular Model into Excel worksheet. Steps sequence: On the Data tab -> From Other Sources -> From Analysis Services Select Database and Model Save Data Connection -> Finish And then appeared the popup window…
Andrey Morozov
  • 7,839
  • 5
  • 53
  • 75
1 2 3
…
99 100