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!!
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
The 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 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.
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.
Recently 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.
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.
I 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.
There 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.
I'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
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?
Does 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
I 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.
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.
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.