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

Excel 2013 Open a file and prompt user with "Author would like you to open as read-only"

I have an excel file. When the file is opened I would like the user to be prompted with the message "The author would like you to open file_abc.xlsm as read-only unless you need to make changes. Open as read-only?" For the life of me I can't find…
mHelpMe
  • 6,336
  • 24
  • 75
  • 150
7
votes
2 answers

References in Excel 2013 VBA editor is grayed out

I need help with a tool I have created for my office team to monitor their effort utilization using Excel 2013 VBA Macro. Unfortunately, the Macro could not find Add-Ins in anyone else's system than mine. In other's system, the "References" button…
Anurag Thakur
  • 101
  • 1
  • 1
  • 9
7
votes
3 answers

Always Allow Native DB Queries

In Excel 2013 how can I change options (or is it possible) to always allow native DB Queries? Can someone walk me through how to set this up?
Habib Inman
  • 151
  • 1
  • 1
  • 7
7
votes
3 answers

Separate octets of IP address using formulas

I want to separate out the octets of an IP address using Formulas. I have tried some things like substitute & find but cannot figure this out. Example of what I want to achieve, by only starting with Cell A1 and Cell B1: 10.17.9.192 | 192.168.0.1 10…
Luke Wolfenden
  • 75
  • 1
  • 1
  • 6
7
votes
1 answer

Create Bar Chart in Excel with Start Time and Duration

I want to create what is essentially a Gantt chart in Excel 2013 with time of day as the x-axis, date as the y-axis, and floating bars representing time durations. Example data: Date Start End Duration 21-Apr 6:45 8:20 1:35 21-Apr …
Erica
  • 149
  • 1
  • 3
  • 7
7
votes
2 answers

Char type not defined

Dim myChar As Char throws Compile Error: "User-defined type not defined" What reference should I include to use Char type?
Marian Becheru
  • 71
  • 1
  • 1
  • 2
7
votes
2 answers

Macro that runs a Macro that opens files and save them as value - Runtime Error 1004

I keep getting this 1004 runtime error. I have slimmed my programing down some so it’s not so Programception. I think it may have to do with using Excel 2010 to save .xls files. Not sure. When Auto_Root.xls opens it runs Sub auto_open() which…
Michael Downey
  • 687
  • 3
  • 13
  • 42
7
votes
1 answer

How to filter an Excel table based on values in a column shard with another table?

To start, I don't think VLOOKUP will work for me because I have dozens of columns in each table. Let's say I have Table 1: Serial# Value1 Value2 Value3 Value4 1 4 34 65 23 2 123 43 54 46 …
SGHAF
  • 105
  • 1
  • 1
  • 5
7
votes
10 answers

Excel Custom Task Pane not showing

I'm showing a custom task pane in an excel VSTO add-in, I'm building it and showing it as thus: var ctrl = new CellTaskPane(); var pane = CustomTaskPanes.Add(ctrl, "Custom Sheet"); pane.DockPosition =…
Clint
  • 6,133
  • 2
  • 27
  • 48
7
votes
2 answers

How do I convert my flat list to a tree list when trying to bulk import from Excel 2013 to TFS?

I've got a lot of product backlog items that I want to load into TFS. We've already got most of these defined in an Excel spreadsheet, so I thought that bulk importing from Excel to TFS as described here would be the best way to go. If I just wanted…
Sterno
  • 1,638
  • 2
  • 17
  • 28
6
votes
3 answers

VBA: Passing multiple values to Instr

Right now I have a long list of "Industry" values that users have submitted through a form. I've written a macro that will search for particular terms in those values and paste values that conform to my significantly smaller list of "acceptable"…
xxxRxxx
  • 357
  • 2
  • 7
  • 17
6
votes
3 answers

excel vba not exporting pagesetup to pdf correctly

I have code which formats a worksheet to the desired setup and layout (one page wide and tall in landscape). When I run the code (part of a long macro) it formats the pagesetup correctly. If I manually export and save it as a pdf, then it uses the…
rohrl77
  • 3,277
  • 11
  • 47
  • 73
6
votes
6 answers

Solver.xlam is missing?

I created a program in Excel 2010 on my PC that relies on the built-in solver for Excel. I made sure it worked on both Excel 2010 and Excel 2013 for PC. I then tried to use this same program on Excel 2011, and ran into an issue. When I tried to…
TheTreeMan
  • 913
  • 8
  • 23
  • 38
6
votes
3 answers

Excel does not open large file

I am trying to open a CSV file in Excel 2013 but nothing really happens. Excel is just opening without anything visible (just the gray background as you have just closed a workbook). The CSV file is 2.7GB. I have no idea how many rows that could…
Pepys
  • 981
  • 7
  • 16
  • 34
6
votes
2 answers

Dynamically call a macro passing parameters from shape OnAction property

Well, my problem is that I have created a VBA Sub that receives an excel Cell reference and 2 text values and a Variant as parameter. Sub CreateButton(oCell, sLabel, sOnClickMacro, oParameters) This Sub succeeds in creating a button over the oCell…
Roger Barreto
  • 2,004
  • 1
  • 17
  • 21
1 2
3
…
99 100