Tagged Questions
0
votes
0answers
21 views
Is it possible to use alt-XYZ shortcuts on Excel on OS X?
I don't want to know the equivalents -- I want to use the same commands. I'm switching between windows at work and a mac at home.
0
votes
2answers
41 views
How to disable “This workbook contains macros”
This prompt comes up each time I open a file which I trust, is there a way to disable it permanently?
0
votes
1answer
61 views
How to remove the “blank” column or row in the pivot table
I want my pivot table to auto update/refresh when I add more data to the table that I am generating the pivot table from. In that case I have selected the entire worksheet to generate the pivot table. ...
1
vote
1answer
3k views
Excel 2011 Mac auto-recover file lost
Yesterday morning my colleagues Excel 2011 (on Mac OSX 10.8) crashed. He reopened Excel and was asked if he wanted to recover the previous document. Yes, he said and then got a document named ...
-1
votes
1answer
51 views
Date in my personal Excel on MacOS displays differently from Windows
I have created a personal Excel document through zipping XML documents.
The structure of this document is simpler than what Excel creates.
The problem is that the date in this document is different ...
4
votes
2answers
120 views
Can I set cells to remember a certain input method in Excel? If so, how?
I have an Excel document with two columns. In one column, I write using the Japanese input method. In the next one I write using the standard one (Latin based).
So, can I set Excel to automatically ...
1
vote
0answers
89 views
Encrypt Excel file on Windows for use on Mac
I have an Excel file open using Excel 2007 on a Vista PC.
I wish to encrypt this file, and send it to someone to open on a Mac running Excel 11.6.6 (Office 2004). Is this easily achievable?
I ...
4
votes
1answer
194 views
Function argument delimiter - Excel 2011 for Mac OS X
I have two Mac OS X machines, both running Microsoft EXCEL 2011.
One uses a comma to separate function parameters, e.g:
function(arg1, arg2)
Yet my work machine uses semi-colons, e.g:
...
0
votes
0answers
61 views
work with huge 15000 lines excel files containing formulas
We work on a huge excel file. it contains a sheet setting 22000 lines
We use Excel 2011 on Mac and Windows on Intel i7 with 8Gb Ram.
We have disabled the automatic computation of the file
the file ...
2
votes
1answer
205 views
How to get the list of sheet names of ms-excel?
I have an excel file which has a lot of sheets. How could I get a list of sheet names of ms-excel?
(PS: The office is mac version.)
1
vote
1answer
122 views
Excel for Mac: Need help converting Windows split to txt macro
just to preface everything, I'm a total vb hack - as in cut/copy/paste and try to make things work. The script below worked on my windows machine, but won't work on my Mac. I get a path/access error.
...
1
vote
2answers
398 views
Automating data from an Excel file and interacting with browser
How can I automate copying records from an Excel file or CSV and interacting with a browser?
Example Task:
Extract or Copy record(s) from an Excel file row
Go to a URL (probably using Google ...
2
votes
1answer
274 views
Spreadsheet application that can handle big data OS X
I've been working with Excel for quite a while for some statistical analysis that I do regularly. The size of the data that I'm working with has gotten much larger as of late, however. The layout of ...
1
vote
2answers
253 views
excel - generate a username from a full name field
I'm trying to generate a username using a single name field in excel which has the person's first name and last name. I'm open to what the username would be, as long as its intuitive for the user. The ...
1
vote
1answer
167 views
Create text file named after a cell containing other cell data
I tried using the code below for the Excel program on my `Mac Mini using the OS X Version 10.7.2 and it keeps saying Error due to file name / path: (The Excel file I am creating is going to be a ...
0
votes
1answer
269 views
Did Lion eat Excel
I'm running on OSX 10.7.3 using Microsoft Office 2008 (with the latest updates).
Recently, Excel started crashing on startup. It happens so fast it is hard for me to detect what's going on but ...
0
votes
1answer
131 views
iodbctest works but Excel says “No ODBC driver installed”
I'm trying to connect Excel in OS X to a Vertica database and I have their ODBC driver working with iodbctest but when I boot Excel and click on Database I get "No ODBC driver installed"
What are the ...
1
vote
0answers
27 views
Microsoft Excel on Mac unintentionally clears my cells
When I navigate through cells using the arrow keys I have encountered some annoying behavior. If I stop at some cell for a second or so, it automatically enters edit mode for that cell clearing ...
1
vote
1answer
242 views
OS X Excel 2008: Export All Document Sheets to Separate Tab Delimited Files
Is it possible to bulk export multiple sheets in an Excel Document to separate tab-delimited text files? As it is, it only exports the active sheet. I've got a document with 850 sheets, all of which ...
2
votes
1answer
494 views
How come I can only forecast a trendline 5 periods backwards, while I can forecast it 1000+ forward?
It doesn't make any sense. I can do it in Excel 2010 on Windows, but not Excel 2011 on OS X.
Workbook I used: http://cl.ly/Ewfe
Screenie:
0
votes
1answer
95 views
CSV - Microsoft office for mac 2008 doesn't add all the commas?
Let's say I have 5 column headings and I only complete the first 2 values. I then save the file as CSV (Windows). It ends up looking like this:
ID,Product,Name,Value,Interest
1,PC
Which is no good ...
4
votes
1answer
477 views
Excel - Formula Cell Entry by Click, can I get eg $A$1 instead of A1?
It is possible in Excel to create a cell reference using $ to prevent Excel from incrementing the row/column designator when the formula is copied. IE, if you fill a formula containing the reference ...
2
votes
2answers
690 views
Change line endings and delimiter format (permanently) when saving to CSV from Excel
I'm using Excel on Mac and it's always painful to have to reopen all exported CSVs in another text editor just to change the line endings from "CR" to "LF" and the delimiter from ";" to ","
Is there ...
1
vote
1answer
3k views
How to import (and view correctly) Chinese UTF-8 encoded CSV file with Excel 2011 on Mac OS X
I have a CSV file which I can open and view the column with Chinese letters normally with TextMate.
However, when I try to import this file into Excel 2011, the field comes with unreadable fonts. ...
2
votes
1answer
915 views
How can I break out of an infinite loop in Excel 2011 for OS X?
I am working on Excel macros on OS X. I am fairly new to Excel, so I commonly encounter infinite loops.
How can I interrupt a running macro subroutine without killing the process?
0
votes
2answers
55 views
How to open a certain document at login?
I have a file:
mydoc.xlsx (Excel spreadsheet).
Is there some sort of terminal command or other setting in Excel or otherwise that makes this particular document open automatically when I login?
3
votes
2answers
423 views
How do you show the toolbar in Excel 2008 on Mac OS X Lion if it's hidden?
In Snow Leopard and earlier, there was a "tic-tac" control in the top right of the window, but after upgrading to Lion, it's no longer there. Any ideas?
3
votes
1answer
156 views
How can I select the region that should be viewed in Word from an embedded spreadsheet object?
Embedding Excel worksheet objects directly into Word seems like a killer feature to me, but it would only be useful for publication if I could choose the "printable area" of the spreadsheet that gets ...
5
votes
1answer
445 views
How to repair a corrupted Excel file
I'm trying to restore some files for a friend who messed up a USB stick by pulling it out of the computer too soon. By searching invisible partitions I was able to restore the files. All files are ...
0
votes
1answer
3k 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
327 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 ...
0
votes
1answer
460 views
Mac Excel SUMIF #NA problem
A formula from a Windows based Excel sheet doesn't work on Excel for OS X:
=SUMIF(P2:P453,"<>#N/A")
The problem seems to be with the "<>#N/A" part.
How should that be written in Excel ...
1
vote
1answer
178 views
My computer isn't loading my massive Excel file…are there any tricks?
I have an 11,000 row Excel file (in Japanese) that I have saved as an xlsx file. I need it to be saved in UTF-8 format, so I went in and tested a few rows in OpenOffice (the reason for this apparent ...
0
votes
1answer
439 views
0
votes
1answer
688 views
Small but full featured xls (Excel) reader for Mac OS X?
Is there a program that allows me to not only read the contents of an Excel spreadsheet on a Mac without being a large download? I presume OpenOffice does it, but I don't have the bandwidth to ...
0
votes
1answer
423 views
Excel, Lookup special characters and spaces
I have an excel, spreadsheet that has multiple sheets.
The first sheet is an index of files, I am using the following forumla to look up a value in column A, references against the index sheet, if it ...
0
votes
1answer
622 views
Excel; exporting/importing different columns to different csv files
Is there a way to batch export different columns to different csv files in excel on an OSX, I'm thinking something along the lines of possibly automator, applescript or bash. I've had a look play ...
4
votes
7answers
23k views
How to print multiple Excel sheets into a single PDF file?
I am trying to print multiple sheets from the same Excel workbook into ONE PDF file. But it frequently prints them separately or only the first sheet.
I selected all the sheets and made them have the ...
1
vote
1answer
2k views
Enter “return” in excel?
It took me a while to find out how to do it on Windows. Now, how do I do the same in Mac?
What's the equivalent for Alt+Enter for Excel on Mac?
