1. What are the file extensions for MAC excel? Do they differ from PC excel?
2. What are the differences between MAC excel 08 vs PC excel 07?
I have had some work done by a provider in elance in PC excel 07 and now i can not read the spread sheet in my MAC environment. The provider is saying that MAX and PC excel versions are 100% compatible - I disagree and need to know the differences but I am not tech/program savvy.
I 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 RelatedThe planned mid-January release of Office 2008 offers a significant overhaul of the productivity suite's look and features.
The previous segment described new features in Word 2008, with some comparisons to Apple's Pages 08. This article examines what's new in Excel 2008 and contrasts Microsoft's oldest application to Apple's newest: the Numbers 08 spreadsheet included with iWork.
I'm taking a class with a professor who uses Windows. We're using Excel (2003) tomorrow in class, and I'd like to use my Excel Mac to do the class.
Is there a big difference with the Mac version versus the Windows counterpart? Enough to make a significant difference?
I 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 RelatedWhen 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
i need this addon for excel which is regression software or something for excel. I cannot find this addon for the mac version and i do not want to use a stupid pc for excel. Any addon that is like regression? i need it for school.
i believe its called rinlex cause in my syllabus it says
In addition to Microsoft Excel an Excel add in called Rinlex is available on the web page and also in the computer lab.
My excel (office 2008) keeps crashing as soon as I open up. I receive this error message:
Microsoft Error Reporting log version: 2.0
Error Signature:
Exception: EXC_BAD_ACCESS
Date/Time: 2009-08-16 20:30:17 +0200
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Version: 12.2.0.090605
Crashed Module Name: libSystem.B.dylib...............
I work a lot in Excel for Mac and I have noticed an annoying feature that I can't seem to change. No matter how many times I save a document in "landscape" it keeps on reverting back to "portrait" every time I open it. I have tried to default to landscape but it has not worked.
View 14 Replies View RelatedI just got a new aluminum keyboard for my Mac Pro. Since I started using it I have noticed one peculiar issue. When I use Excel, the arrow keys no longer move from cell to cell. Instead, they shift the whole spreadsheet. It's not a huge deal, but I think I should be able to select cells using the arrow keys.
View 2 Replies View RelatedThere are absolutely no add-ins for Excel 2008 for mac! I really need the data analysis toolpak for school and work. Does anybody know if it's possible to download this toolpak from somewhere and install it? I've tried looking and have come up with nothing so far.
View 12 Replies View RelatedMicrosoft Error Reporting log version: 2.0
Exception: EXC_BAD_ACCESS
Date/Time: 2009-04-20 23:11:30 -0400
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Version: 12.1.7.090302
Crashed Module Name: libobjc.A.dylib
Crashed Module Version: unknown
Crashed Module Offset: 0x0001568c............
I am wanting to do a t-test in Excel (for a class I am teaching). So as a practice, I did this (in columns A and B):
3413
3523
2329
13200000
14200000
5612
43
These are my two groups, with means:
31.1428571466679.5
Certainly the means seem different!
However, the ttest procedure gave me this p-value:
0.174751284
The formula was this:
=TTEST(A1:A7,B1:B6,2,3)
I was wanting to know how to sort a list of birthdays in excel by month and day only (Not including years); I also tried to add only the month and day data but it kept sticking 2010 on the end.
View 1 Replies View RelatedLet's ignore for a moment how awful Microsoft Office products are on a mac. Anyone know how to turn on spellcheck? I don't see it in the preferences.
View 1 Replies View RelatedI've created a PDF file using the PDF feature in Excel (Office 2004) on a iMac running 10.5.8 . The file appears to be OK. I open in Acrobat 8.1.5 and send to print, the file spools - but never prints.
I've sent this file to other users with the same result. They can open the file, but cannot print from acrobat. In all cases:
- I can print other PDF files not created in Excel.
- I can print the problem file using Mac Preview option.
When I view the file information:
The Content Creator is: Microsoft Excel
Encoding software: Mac OS X 10.5.8 Quartz PDF Content
Cannot get Excel to open; any ideas?
Info:
iMac, Mac OS X (10.6.8)
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)
Everything was working fine until I opened a mail from a friend who sent me an excel file (from a PC).
Info:iPhone 4, iOS 5
On my ipad/iphone I have docstogo which I use for my Microsoft excel work, but what do i need to use to do the Microsoft excel work on my new MacBook Pro?
Info:
MacBook Pro
I have read some complaints about what happens with some big excel benchmark or something but try this one on for size: Making a chart with 6 data points took 1 full minute to make and scrolling down after the thing was rendered, damn near impossible! seriously, Office 97 on a 486 beat this! with the right IO,, a FREE CELL PHNE could beat this! I have a brand new Macbook, smoking fast... Can we sue MS for a defective product?
View 9 Replies View RelatedDoes anyone else have problems copying figures (charts) made in Excel into Word? When I copy the figures into Word, they appear ok on a MAC, but when viewed on a PC, the y-axis disappears. I am using Office 2004
View 3 Replies View RelatedI have five different excel files on the dock (they appear below the line, along with the trash icon). When I click on them a question mark appears on top of the excel symbol, and "help" says this means they have been deleted. None of them were saved anywhere but on the dock. But I have not opened three of them for weeks, and cannot find any of them with "finder". I always save when prompted before closing the Excel application, and would never knowingly delete them, as they represent hundreds of hours of work.
I'm on a Mac mini, with OS X 10.4.11
I'm lucky enough to be in Excel 2007 and have infront of me 3 columns of data.
As an example, in the first column is the colour of a product, 2nd = the price, 3rd column = quantity in stock.
Now I know that I can use an array formula to come up with a way of finding out the number of red products that are �2 and have 2 items in stock - unfortunately I am not sure how to do this!
Operating System: Mac OS X 10.6.3 (Build 10D2094) CPU: Intel Core Duo, Number: 4, Speed: 2147 MHz
Haven't had a problem to date and after opening a file that excel obviously struggled with for some reason, excel open briefly then I encounter the following error message. Much obliged for any help or guidance.
Error Signature:
Exception: EXC_BAD_ACCESS
Date/Time: 2010-09-27 21:45:42 -0400
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Version: 12.2.6.100708
Crashed Module Name: libobjc.A.dylib...............
I'm currently trying to create some graphs in Excel, and the data isn't plotting as I would like it to be - not sure if there is something I am doing wrong here or if there is a setting to change. My data goes like this:
Mass (g)Average Period (s)
502.074
752.089
1002.110
1252.111
and I would like mass on the x-axis and average period on the y-axis. However, my graph is placing both values on the y-axis and placing a key beside the graph. The graph and the way I have set out the data are attached below.
