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

Excel 2013 VBA Error

I am getting following error. Compile error: The code in this project must be updated for use on 64-bit systems. VBA CODE Option Explicit Private Declare Function URLDownloadToFile Lib "urlmon" _ Alias "URLDownloadToFileA" (ByVal pCaller As Long,…
Mowgli
  • 3,422
  • 21
  • 64
  • 88
6
votes
4 answers

mysql for excel

I am not sure if this is the right place to ask this question but I am facing an issue with MySQL installed failing to recognize office 2013 and install MySQL for Excel. Basically MySQL https://dev.mysql.com/downloads/ Has an addin for excel that…
JsEveryDay
  • 313
  • 2
  • 5
  • 16
5
votes
4 answers

How to ignore case in string comparison

I have an Excel VBA formula:- If [G56] = "Not Applicable" Then ... It is case-sensitive. I want it to ignore the case of "Not applicable".
sheetal singh
  • 119
  • 1
  • 2
  • 10
5
votes
3 answers

Remove cell from Range (object)

Background My code does some loops over ranges, however, each interaction should be performed in the range excluding the cell just performed. I think the easier way to do so is to remove the cell from the stored range. Problem I have not been able…
Sgdva
  • 2,800
  • 3
  • 17
  • 28
5
votes
1 answer

Text in cell repeats or doubles, why?

I typed in =NOW() and the cell displayed "1/6/20161/6/2016". Checked cell format and conditional formatting and nothing seems amiss. What can cause this? edit: as shown in the image below, I cannot recreate the anomaly outside of this column. …
elt2jdavis
  • 231
  • 2
  • 3
  • 13
5
votes
1 answer

Excel and RabbitMQ - Process RabbitMQ Messages in Excel?

I would like to subscribe to a RabbitMQ message queue from Excel 2013. The ultimate aim is to allow data contained within a MQ message to be processed within Excel and to also allow Excel to send a formatted message via a RabbitMQ message queue. Is…
Mark Smith
  • 757
  • 2
  • 16
  • 27
5
votes
6 answers

Creating a "color scale" using vba (avoiding conditional formatting)

I'm looking for a way to apply a color scale to a set of cells via VBA code but not by applying some conditional formatting... I want to apply them as static colors (InteriorColor) I've searched plenty of excel sites, google and stackoverflow and…
Ryflex
  • 5,559
  • 25
  • 79
  • 148
5
votes
3 answers

Loop through folder, renaming files that meet specific criteria using VBA?

I am new to VBA (and have only a bit of training in java), but assembled this bit of code with the help of other posts here and have hit a wall. I am trying to write code that will cycle through each file in a folder, testing if each file meets…
Joe K
  • 85
  • 1
  • 1
  • 9
5
votes
3 answers

Calculation with values expressed in different units (KB, MB, GB)

I am looking for a simple way in Excel to calculate with units of different values. I have a list of several values in KB, MB and GB and I want to get a calculated output in GB. Here's a piece of the list: 66.0 MB 570 KB 1.10 GB 2.21 KB Output: ???…
Just a user
  • 609
  • 2
  • 10
  • 19
5
votes
2 answers

Use INDEX MATCH to find greater than/equal to value

I've been searching online and in Excel Help but cannot find whether this is possible. Given a list of numbers, values and a search term, I need to find the value whereby the value is greater than or equal to the search term. See the…
EvilDr
  • 8,943
  • 14
  • 73
  • 133
5
votes
0 answers

Excel 2013 VSTO Ribbon & Edit Controls

The quick overview is I have an Excel AddIn targeting Excel 2013. The AddIn has a custom RibbonUI that contains a couple of read-only EditBoxes that contain workbook specific values. The same AddIn works fine in Excel 2007 & 2010, with the MDI…
Nathan Ernst
  • 4,540
  • 25
  • 38
5
votes
9 answers

Excel 2013 worksheet activate

I have an issue with activating a sheet from a user form, the same code works fine in Excel 2003 to Excel 2010, doesn't work with Excel 2013. This is how to simply reproduce the issue: Have a workbook with 2 worksheets in it, called Sheet1 and…
user2766088
  • 51
  • 1
  • 1
  • 2
5
votes
3 answers

Error Creating Power View sheets from SSAS Tabular

I am getting a strange error when creating Excel 2013 Power View sheets off an Analysis Services (SSAS) Tabular instance running on an Azure VM in the cloud. Here is the error: Sorry, something went wrong while loading the model for the item or…
Jondlm
  • 8,764
  • 2
  • 24
  • 30
5
votes
2 answers

Conditional compilation based on Excel version

I know that I can use conditional compilation in VBA to differentiate between the 64bit and the 32bit version (using #If VBA7 Then ...). Is there also a build in constant similar to Application.Version so that I can differentiate between Excel…
Peter Albert
  • 16,917
  • 5
  • 64
  • 88
4
votes
2 answers

Below Code not working on large selection

for large data selection (1000 + cells) below query is not working but for small it's working. Excel stopped working unless i press escape. Sub TrimReplaceAndUppercase() For Each cell In Selection If Not cell.HasFormula Then …
Mahesh Jadhav
  • 45
  • 6
1 2 3
…
99 100