The 2011 version of Microsoft's spreadsheet application for Mac.

learn more… | top users | synonyms (1)

1
vote
2answers
4k views

Opening a file for output/input in Microsoft Visual Basic on Mac OS X

I am working in Excel for Mac 2011 and my goal is to create a simple macro that writes particular cells to a file. This is generally a simple task, but VB chooses not to accept a file path. For ...
0
votes
1answer
1k views

Excel: Filter Pivot Table from Another Sheet / Duplicate Filters Across Sheets

I am working with Excel for Mac 2011. I have several different pivot tables that each organize data for graphing on a summary sheet. Every pivot table should be filtered the same way. Questions: ...
2
votes
5answers
7k views

How can I get Excel 2011 to stop opening my Personal Macro Workbook?

Ever since I created a couple of macros in Excel for Mac 2011, the Personal Macro Workbook opens every time I open Excel. How do I keep that from happening? I have since deleted the macros, but I ...
0
votes
1answer
1k views

How can I sort by word/token in Excel 2011

Is it possible to sort a spreadsheet based on if a word is contained in cells within a column? Like if I take the "title" column and sort, keeping the rows connected, to bring all the rows with a ...