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

Does `Application.StatusBar` work in office 2011?

I wrote this little macro on my mac using office 2011. I don't see any status bar. Anyone know why this is not working? Sub testStastusBar() Application.DisplayStatusBar = True Application.StatusBar = "Now processing...." Dim n As…
DBWeinstein
  • 8,605
  • 31
  • 73
  • 118
1
vote
2 answers

If value not found, display "--"

I have a sheet (LC AVERAGE) that has a list of names and a column of values. I am looking to display the values on an OVERVIEW sheet that I have, but there are more names on the OVERVIEW sheet than on the LC AVERAGE sheet. I tried IFERROR and IF,…
Adam Makharita
  • 35
  • 1
  • 8
1
vote
1 answer

Excel Function - If date between range, display average

I know very little about writing Excel functions and I'm a bit stuck. I have an overview page on an Excel doc and I am trying to display averages for each employee. The issue here is that I can't get the correct average. The average needs to: Be…
Adam Makharita
  • 35
  • 1
  • 8
1
vote
0 answers

How to remove Help button from CommandBar Popup menu

I'm using the Application.CommandBars.Add method to create a custom PopUp menu. I'm on a Mac with OS 10.8 and using Excel for Mac 2011. I get a Help button at the top of menu that I didn't ask for. It does work, as in it launches the Help Center. …
MacroMangler
  • 21
  • 1
  • 3
1
vote
1 answer

how to download data using vba excel 2011

I've seen this answer: html parsing of cricinfo scorecards these variable types, however, are not available in excel 2011: Dim tbl As HTMLTable Dim tr As HTMLTableRow Is there another way to get data from the web using excel 2011?
DBWeinstein
  • 8,605
  • 31
  • 73
  • 118
1
vote
1 answer

Dynamically construct range to use in XIRR formula

I have a sheet in this form: Fund | Date | Amount A | 10-Jan-05 | -5000 A | 10-Feb-05 | -5000 A | 08-Oct-13 | 12500 B | 10-Sep-05 | -5000 B | 10-Oct-05 | -5000 B | 10-Nov-05 | -5000 B | 08-Oct-13 | 22500 I'm looking for an…
Karthikeyan
  • 143
  • 3
  • 9
1
vote
2 answers

Add Percentile_Inc to Excel 2011 MAC?

It semmes that Mac 2011 does not includes Percentile_Inc. My question is simple, is it possible to add Percentile_Inc in Excel 2011 MAC version ? Thanks in advance. bee
David
  • 427
  • 1
  • 5
  • 21
1
vote
1 answer

How to combine reverse-chronological sheets while rearranging cells, preventing stacking?

OK, I will try to explain this well. An odd problem to solve, and it's WAY beyond my skill level (novice). Excel 2011 for Mac. The workbook has 11 sheets. Sheet names are all 'Month Year'. (Eg: sheet 1 is titled "June 2013") Sheet names are reverse…
user2601892
  • 23
  • 2
  • 7
1
vote
1 answer

Save custom macro toolbar modifications in Excel 2011 for Mac

I produced several custom macros in Windows, modified the XML so that a custom Ribbon Tab was visible in the 2013 version of Windows, and everything was wonderful. I'm now trying to produce equivalent functionality for Excel 2011 for Mac. I did the…
Parseltongue
  • 11,157
  • 30
  • 95
  • 160
1
vote
1 answer

3-Color Scale to change color in different columns from data in another column

I have an Excel document with First Name and Last name in columns A and B. Data related to those names in column C in Percentages. I have been able to conditionally format percentile in the data column C based on values in a 3-Color Scale but I…
user2498376
  • 11
  • 3
1
vote
1 answer

Mac Excel 2011 VBA Evaluate

I am moving a excel VBA from PC to Mac and one line has an Evaluate function, for example: Public Function test() test = Evaluate("=2+2") End Function However, if I try and run the macro on the mac the function returns #name. Is there an…
pdoak
  • 721
  • 8
  • 21
1
vote
0 answers

Export to Excel, error opening in Microsoft Excel

I have a very long string (about 700 characters) that I need to export to a single cell. $pdf->Cell(150,$h,$model->data["value"]); When opening it using Microsoft Excel it gives me a "File error: data may have been lost." whereas with OpenOffice it…
Tom
  • 176
  • 1
  • 11
1
vote
1 answer

Office 2011 Mac: How to link existing excel chart to powerpoint?

how do I link an existing chart in an excel sheet into a powerpoint presentation in such a way that when I change the excel file is change the powerpoint will be changed, too? I found http://goo.gl/GcQa8 But when I use this "Chart linked with excel…
JerryWho
  • 3,060
  • 6
  • 27
  • 49
1
vote
2 answers

Excel: count number of times a value occurs in a column

Gah, I know this has to be easier than I am making it out to be: I have a simple spreadsheet of three columns. The first column is the one I am interested in: it contains a value from 00-49. (These numbers indicate the topic under which an item in…
John Laudun
  • 407
  • 1
  • 9
  • 19
1
vote
1 answer

Date for VBA not working in Excel 2011?

Here is my code, I am attempting, which works BTW on a PC, but not on a Mac, to run this code and have an excel sheet created, named, add a tab, change the color of said tabs, change the name of said tabs, and then transpose the data while…
Matt Ridge
  • 3,633
  • 16
  • 45
  • 63
1 2 3
…
10 11