Stack Overflow
Stack Overflow

Questions tagged [excel-2011]

Excel 2011 refers to the spreadsheet editor included in Microsoft Office for Mac 2011.

151 questions
1
vote
1 answer

Macro to copy worksheet irrespective of worksheet name?

I export lots of information to a .csv file then download/open for manipulation. Each export is sequentially numbered (eg export (22).csv, export (23).csv etc hence the worksheet is also given the same name/number. For each .csv file that I open, I…
ShorTControlleR
  • 79
  • 10
1
vote
0 answers

Disable "... not supported by Excel for Mac 2011" dialog box

When I use the following line to open an xls file, sometimes there is a dialog box popping up. Workbooks.Open Filename:=path & fFile, UpdateLinks:=xlUpdateLinksNever, Password:="", ReadOnly:=True My question is, whether it is possible to always…
SoftTimur
  • 5,630
  • 38
  • 140
  • 292
1
vote
1 answer

How do I get a list of non-contiguous values from a row in Excel (ignoring blanks)?

I am restructuring a few datasets and need to retrieve a list of non-contiguous values in a row in Excel for Mac. There are cells with blank spaces that should be discarded, so the result is a horizontal list of the same values, without the blank…
user5225119
  • 35
  • 5
1
vote
1 answer

How do I make a PivotTable with numerous columns/values that don't layer?

I have a fairly large dataset that looks similar to this if I limited it at four rows: Staffer Name Registration Due Confirmation Julie Ryan Registered Unpaid Not Confirmed Julie Sarah …
Ryan
  • 501
  • 1
  • 12
  • 26
1
vote
1 answer

Easiest way to get either LibreOffice Calc or Excel to import ISO8601 datetimes

Using Python3, I've made a bunch of log files, which include datetimes rendered with the iso_format() method. E.g. ... 2015-04-09T18:31:56.285000 12.7 2015-04-09T18:31:56.285000 12.6 2015-04-09T18:32:16.662000 12.8 2015-04-09T18:32:36.231000 …
Travis Griggs
  • 21,522
  • 19
  • 91
  • 167
1
vote
1 answer

Sumif between two dates over two columns

I would like to sum a column between two dates, however the dates are in separate columns. I want the sum total between the following dates 01-01-2014 (cell E1) and 31-03-2014 (cell F1). If you look at cell C6 the date is lower than the first…
Anthony
  • 879
  • 3
  • 11
  • 17
1
vote
3 answers

Get date value based on month name

The scenario I have is as follows: Cell A1 - contains the name of the current month, e.g. "October" Cell A2 - contains the value of the current year, e.g. "2014" Cell A3 - contains the value of a given day, e.g "22" I'd like to populate A3 with a…
danw
  • 1,608
  • 4
  • 29
  • 48
1
vote
3 answers

ExecuteExcel4Macro Method fails in Excel 2011 on Mac with 1004 Error

So I'm another one of those wanting to use the ExecuteExcel4Macro Method call to retrieve data from specific cells and lookup ranges in closed workbooks. I have seen lots of examples and answers to problems here and elsewhere. I am (or will be)…
MacroMangler
  • 21
  • 1
  • 3
1
vote
1 answer

Checkbox not working on mac

I wrote an excel VBA macro that works with checkboxes. To check whether the checkbox is selected or not I use the following code: Sheet4.Shapes("dietary").OLEFormat.Object.Value This works well on a windows PC; however, a colleague uses a mac and…
Mustika
  • 191
  • 1
  • 5
  • 13
1
vote
1 answer

Baffling behaviour when summing reciprocals

I'm trying to quickly compute the sum of reciprocals of several values using Excel 2011 for Mac. Most of the documentation and answers I can find online say it should be as easy as =SUM(1/rangestart:rangeend) but I'm getting unexpected results and…
Calyo Delphi
  • 329
  • 1
  • 3
  • 16
1
vote
2 answers

Create text files from data rows in Excel

I have a source spreadsheet in Excel with 450-or-so rows. Each row has 6 columns of data, and I need to create a separate file from each row with the filename = Column A and the contents = Columns B-G with a line break between them. For example, I'm…
Daniel Fowler
  • 385
  • 7
  • 21
1
vote
1 answer

Matching data based on IDs

I have two sheets, one is a huge table of item ID's with a corresponding code column next to them. However over time this has not been properly filled in. I have assembled a complete list of item ID's and corresponding codes in another sheet. I…
user3234810
  • 482
  • 2
  • 5
  • 18
1
vote
1 answer

Method 'Close' of object _Workbook failed when using UserForm in Excel 2011

I have already looked at these two posts: Closing a Userform with Unload Me doesn't work Error when closing an opened workbook in VBA Userform They both suggest that when you want to close a file from Form code, you need to Unload the Form first…
colej1390
  • 157
  • 4
  • 11
1
vote
3 answers

Reduce fractions representing increments of 0.0625

Using Excel for Mac. I want the formula to round decimal numbers to fractions. The smallest increment I would want is 1/16 (which I can easily do) but I want automatically to reduce sixteenths to 1/8, 1/4, and 1/2 when appropriate (not rounding…
AgileMan
  • 35
  • 1
  • 1
  • 9
1
vote
0 answers

Mac Excel 2011 Userform

Is there a way to perpetually display a button-click userform on the spreadsheet for Mac Excel? I know the Windows version is capable of such a command. I've tried Userform.show Unload Userform This code displays the userform, however, once it…
File_Not_Found
  • 45
  • 3
1 2 3
…
10 11