In Excel for Mac (Office 2011), simple copy-paste operations can take a few seconds even with small files with no complex content. Sometimes Excel files also take very long to open.
Info:
Mail, Mac OS X (10.7.3)
Why is my mac running slow, especially with excel spreadsheet?
Info:
MacBook Pro
I'm trying to use Excel 2008 (I wish I still had my old 2004 CD with me) to do some plotting and it's near impossible. I'm plotting spectrum data off of an optical spectrum analyzer, so we're talking some 3000 data points. I select the data, create a chart (annoying as hell in itself) and once the chart shows up I can't do anything without at least a 10-20second wait, I can't select an axis, move the chart, rename it or anything. Why is this so slow and is there anything I can do to speed things up? Doing such plotting using an old school Excel on an old computer running Windows 2000 was no problem at all.
View 7 Replies View RelatedI am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.
It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.
What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.
Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?
1. Turned the List Manager on by accident in Excel. Can't figure out how to turn it off now. I am using Excel 2004, and a MAC mouse - so no right-clicking for me...
2. How do I move columns in Excel? I select the column on top, but then try dragging it to a place I'd like it to move, but nothing happens. How do I do that?
3. General Mac Word/Excel question - how do I get to use "Home" and "End" buttons? When I hit them I simply jump somewhere, but not to the beginning or end of the paragraph. I have a MAC keyboard with the "Home" and "End" buttons along with the "Help", "Delete", "Pg Up" and "Pg Dwn" keys - basically it looks a lot like a PC keyboard...
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!
View 3 Replies View RelatedI have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do
View 1 Replies View RelatedI recently purchased my first MAC with Excel for Mac 2008. I am unable to open any files created in it on my PC which has Excel 2003. Apple is of no help. They had assured me of compatibility at purchase citing the new open format. The MAC Excel 08 file won't open on the MAC on which is was created with their Numbers program either.
View 4 Replies View RelatedI am contemplating upgrading my MacBook Pro (2011 model) from Snow Leopard to Lion. I am concerned about the level of strong criticism about Lion, especially the comments that MS Word and Excel (and Powerpoint?) cannot run in Lion. What is the full story? Can I run MS Office products by reloading them into Lion environment?
Info:
Mac OS X (10.7.3)
Excel is opening closed files from prior sessions when I log into my Mac Pro on Lion. I want excel to launch at log in, but I don't want it opening a lot of files that I have no interest in and since they are big, they take a lot of time to open. I haven't been able to find the setting that will eliminate this problem. Does anyone have any information about whether there is a setting or whether this is "a Feature"?
Info:
Mac Pro, Mac OS X (10.7.3)
has anyone had an issue with office mac 2011 excel and osx lion? i make excel spreadsheets with pdf storyboards on them, and too often the excel file will not reopen. instead i get a corrupt file notice. i choose fix file and the file opens without the pdf files. sounds like a pdf/excel issue to me. it is maddening.
Info:
Mac OS X (10.7.4)
how do i use excel now i have upgraded to lion
Info:
MacBook, Mac OS X (10.7.4)
MS Excel doesnt work after update to 10.7.3.
Info:
MacBook Pro, Mac OS X (10.7.3), Update
I am running a MacBook Pro with OS X 10.7.3 and the latest version of Office 2011 with all the updates installed. Both run very slow and now I noticed that when I click on either icon in the dock it says "Application Not Responding" even though the applications are responding, just very slowly. If I close either application and then reopen it, the message is gone until I open a new document.
Info:
MacBook Pro, Mac OS X (10.5.2)
I've just upgraded to Lion 10.7.3 and tried to open an excel spreadsheet but it only opens in 'Preview' which is uneditible.
Info:
iMac, Mac OS X (10.7.3)
my microsoft excel 2011 is not working with the os x lion. why is it so? whenever i try to to open it it will automatically close.. and a report will popo up and say microsoft excel cannot be opened because of a problem, should i reinstall my excel then?
View 5 Replies View RelatedI have loaded windows 7 and parallels. I want to load MS office so I can send properly formatted excel and doc files to my client. They say the numbers conversion does not translate well to Excel and pages to word. Do I load MS Office in the windows OS? How can i access the numbers file in the Mac OS to use in the Windows OS on Excel? Is this a better option than loading Office for Mac? I need the formatting that I put into the excel file lto hold.
Info:
iMac, Mac OS X (10.7.3)
Every time I start up my Macbook Microsoft Word and Excel open up. How do stop this from happening?
View 3 Replies View RelatedOSX 10.7.4 with Excel 14.2.2.(for Mac 2011) and Dropbox: Original files are saved in Dropbox folder on Mac; Aliases are created there and stored local on Mac HD. Using Finder and navigating to Alias works fine; files open, can be modified and resaved. However, using Excel File Open command and navigating to the same Alias results in "File Not Found or Could Not Be Opened" error message.
Info:
MacBook Pro (13-inch Mid 2009), Mac OS X (10.7.4)
How can I import over 400 names on an Excel spreadsheet in to my address book?
View 3 Replies View RelatedIn microsoft office 2007 for windows it was possible to embed an excel table into word.However i cant seem to find that feature in office 2011 for mac.Is it possible?
View 3 Replies View RelatedI just upgraded my operating system and added more memory to my imac. Word and Excel cannot be used with Lion. How do I delete these from my computer and is there a way to make sure I am optimizing the space on the hard drive?
Info:
iMac, Mac OS X (10.7.3), added more memory
I purchased my MacPro last November. I loaded NUMBERS on my macnine as well as PAGES, and KEYNOTE. I was determined to learn these programs and not rely on using MS OFFICE on my Mac. The rest of my office is still using PC/s and therefore when I am sent a document, it is with MS OFFICE. Up until the first of March, I was able to access all documents sent to me, but sometime in March, EXCEL files sent to me gets an error message:
This document was created with an unsupported version of Excel. Only documents created with Excel ’97 or later can be opened.
It seems to associate to the upgrade that came out for LION during that month. I have tried everything. My office has tried sending in every format without success. WHAT CAUSED THE CHANGE?
Info:
MacBook Pro (13-inch Early 2011), Mac OS X (10.7.3), HP F4500 Printer
When I start up my mac, my word, excel and powerpoint applications open as well.
Info:
iMac, iOS 5.1
Is there a wayof changing the color of the border of the active cell in excecl?
I have a very difficult time seeing the pale green. I waste a fair amount of time modifying formulae because I'm in the wrong cell. Making it a different color or making it more vivid, or bold, would be great.
Tried going into Apple preferences and Excel preferences, but did not have any luck. Maybe I just didn't do the right thing once there.
Info:
iMac, Mac OS X (10.7.4)
When I send my .xls files from my Mac (Office 2008) to my boss's Windows machine (Office 2003), he gets an error message when he attempts to open the excel spreadsheet: Excel has encountered an error and must shut down. I've sent files to other computers and not had a problem, and my boss has received other excel files and been able to open them. So it must be something between these two machines/softwares that is affecting it. Any suggestions or ideas? I can add any additional info you need.
View 2 Replies View RelatedRecently switched from PC to Mac, I really miss the F2 functionality in Excel for Mac
Or, more specifically , I am missing the possibility to place the cursor in a cell and hit F2 to edit the formula as well as Excel color-coding all cells that are referred to from the current cell.
I know I can do the same by clicking in the "formula builder toolbar" but I don't wan't to have to reach for the mouse each time... does anyone know if Excel for Mac has a similar feature / keystroke to use
After upgrading to Lion, I can no longer see the text in my word documents or excel worksheets. I know the text is there because it appears in the formula bar - it just isn't visible in the cells. I can also see the text if I quickview the excel files. In the word documents, all I can see are the pictures/images...no text. Weird. I have the latest version of Office 2008 and Lion OS.
View 2 Replies View RelatedExcel on my mac is so confusing and i have never used it before. It prints out everything but the grid lines for the graph..without the gridlines, the graph looks weird and not easy to read..The print preview shows the grid lines on the mac but when it prints out, i get a weird graph..
Info:
MacBook Pro, Mac OS X (10.7)
Since updating to Lion, Word and Excel open the last opened document when I start the program. How do I disable this?
Info:
MacBook Pro, Mac OS X (10.7.2)
