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

VBA - Check if named range is hidden. If not hidden, AutoFit cell Row height

I have a dynamic table that is tied to a SharePoint list. At any given time only 1 column will be visible for report generated on the spreadsheet. As the table may grow or shrink, I need a routine that can adjust to any number of rows and then look…
StillLearning
  • 45
  • 1
  • 1
  • 6
4
votes
1 answer

delete blank rows on an excel worksheet, in a different excel workbook, using vba

I have 2 work books. Book_A and Book_B. I want to delete blank rows in Book_A worksheet1, from Book_B worksheet1. I have written a code using VBA to delete blank rows. Sub RemoveEmptyRows() ' this macro will remove all rows that contain no…
adrian
  • 284
  • 2
  • 4
  • 14
4
votes
1 answer

Excel 2013 toggle read only

I have an application that I've written in Excel 2003 and I have recently upgraded to Excel 2013. In the workbook_open event I set the workbook to read-only ActiveWorkbook.ChangeFileAccess xlReadOnly and have used the Toggle Read Only button to…
Ronson Lamond
  • 41
  • 3
4
votes
6 answers

Special characters (letters čćžšđ) in Excel 2013 VBA code

I made a program in Excel 2010 VBA that contains letters like ć č š... Msgbox("Čiča gliša") works. Looks like Excel 2013 supports those letters in cells and formulas, but not in VBA. VBA replaces them with some symbols which aren't even on the…
Jelovac
  • 138
  • 1
  • 3
  • 14
4
votes
2 answers

How to convert 14 bit Hex to Decimal

I need to be able to convert 047C1BEA3A2480 into Decimal. This should convert to 1262359242482816. I have a large amount of hex numbers that need converting so would need a formula or VB script. I have tried some things including a VB Module,…
Leigh
  • 133
  • 1
  • 10
4
votes
1 answer

Excel VBA - call same macro from both Ribbon and AutoOpen

Having just upgraded to Excel 2013, I've moved my macros from a legacy custom toolbar to a custom ribbon menu. All works well, except for one thing. I used to have a macro that ran on AutoOpen, but could also be called manually via a button on the…
Optical Race
  • 63
  • 1
  • 7
4
votes
1 answer

Forward Compatibility of Office Addins

I have built an add-in for office 2010 using VS 2010. I have followed these steps to create the msi but when I tried to install it with office 2013 I get an error telling me that: "A required component for interacting with excel is not…
Pat Mustard
  • 1,852
  • 9
  • 31
  • 58
4
votes
2 answers

Independently sort multiple columns in excel

I'm trying to sort a large number of lists from A to Z. But if I sort column A, I don't want all other columns to be rearranged. I need all these lists to indivually be sorts alphabetically. I know it's possible to do one by one but I have 278…
Batman
  • 5,563
  • 18
  • 79
  • 155
4
votes
2 answers

How to Count number of text instances in excel?

I have a table of my workdays and I want to count instances of word 'work' in each row. I have a table like this: I used this code in J1 cell but it doesn't work. =SUM(IF(2:2 = "Sleep",1,0)) I have found this formula in microsoft's website but it…
Erfan Jazeb Nikoo
  • 978
  • 3
  • 12
  • 36
3
votes
1 answer

How to reference an old version of the VBA library?

I'm using Excel 2013. The VBA reference is part of Excel (built-in) so I can't remove it. Is it possible to reference another version of the VBA library? The reason I want to know other than curiosity is to look at the object browser of the older…
user7393973
  • 2,270
  • 1
  • 20
  • 58
3
votes
1 answer

How to connect MS Excel to Azure Cosmos DB-SQLAPI?

I need to create an Excel table who can query the Database and interpret the data into styled tables so the users can understand it. It's supposed to be able to query the whole server and put the outputs into precise columns, even if they come from…
Ztar Tester
  • 41
  • 1
  • 3
3
votes
1 answer

Why is POISSON function not consistent in Microsoft Excel?

There is a definition in POISSON function that: #NUM! error – Occurs if either: The given value of x is less than zero; The given value of mean is less than zero. But I try to do this in Excel 2013. It gave me differnt value. Here is my…
user3698799
  • 71
  • 7
3
votes
1 answer

Perform action upon workbook being reactivated

I've got a workbook which has buttons which open other workbooks through VBA. My understanding is that this initial workbook (lets call it the Hub workbook), is both ThisWorkbook and ActiveWorkbook when I'm in it. Upon opening another workbook…
Satkin2
  • 201
  • 4
  • 11
3
votes
1 answer

Power Query SQL Server connection - authenticate "windows alternative user account"

I am using Excel 2013 PowerQuery addin to connect to SQL Server database. I have Excel open with my user account (domain/Sherlock); which does not have read access to the database (myServer/myDB). I have the credentials for another Windows user…
SherlockSpreadsheets
  • 2,062
  • 3
  • 27
  • 47
3
votes
2 answers

Replacing all letters in Excel

I have cells with values like 01EL041 in Excel and I would like to replace all letters with a fixed character (in my case, 0, leaving 01041 in this example). Is there a good way to do this without VBScript? I know I could do 26 SUBSTUITUTEs but that…
Charles
  • 11,269
  • 13
  • 67
  • 105
1 2 3
…
99 100