Applications :: Cannot Format Cells In Excel Files Sent Via Entourage
Jun 10, 2009
When I get sent an excel file (.xls) I open the attachment, however if I choose Open it doesn't let me format the cells but does let me write and save. If I choose Open and Remove Macros it opens in Read Only however it does let me save whatever changes I've made but still won't let me format the cells. Is there a way to format the cells of these files that get sent to me via Entourage. Even if I save them to desktop I get the same results.
I was updating sheets for the new year. I keep lot of my template the same from year to year, just deleting the items in cells and starting over. It?s easy when using the PowerBook from a keyboard. The Delete key does the trick, but how do I do it from the Powerbook keyboard. The Delete key just does one cell at a time?
I am just trying to alternate the row colors of excel by selecting all cells and then going to autoformat and selecting "List 1." It then takes forever to load and freezes. I have to command + alt +esc to get out of excel. Does anyone know why this is happening?! I have mac excel 2008.
I am getting tired of using Microsoft Entourage for my POP3 email and I want to move over to the Mail app. Is there a way in Entourage to export all my mail into a format that Mail can import all of my old/existing emails?
Every time I change the cell format in numbers, it keeps going back to 12/30/11 when I want 2/1/12. It is quite frustrating because I did what it said to do.
I'm not changing back to a Windows user, it's just that I *need* to get my contacts onto Outlook 2007 as well. My contacts in Entourage are organized nicely, with each contact's name and e-mail address. Really simple information. I then go to "Export", and choose to export the contacts to a "tab-delimited text" file (it's my only choice). Basically, I get this .txt file. I then go to my Outlook 2007, and have tried importing both "Comma Separated Values" and "Tab Separated Values" with my .txt file. Unfortunately, while each contact's name and e-mail DO get imported, the format is completely messed up. I get this "map field" window when I choose to import by Tab Separated Values, but I've tried all different combinations, and every time, the names and e-mails simply jumble up altogether. Has anyone tried importing Entourage contacts into Outlook 2007? And if so, can you please give me some instructions on how to do so?
I have these Numbers files but need to send them to someone who is using a pc with MS Excel. She won't be able to read the files if they are left as .numbers. The odd thing is that I have successfully saved some of the files as .xls and .xls.xls and even some as .xls.numbers.
However, I have lost data when doing some of these savings - I have been taking the .numbers file and trying to save it as .xls but when I open the newly-saved file there's nothing there. Please look at the attached snapshot of my folder structure. Can you anything in there that might be causing my problem? The red arrows are just to highlight the ones I'm particularly interested in.
I'm downloading different files into excel (some tab delimited, some csv, some xls) from different places and they all open in excel with incredibly weird formatting. Basically the separation of each column makes no sense. When other people download the same exact files, their files appear normally, with each category in a different column. So there's something going on with my excel.
When I download a credit card statement, for example, it comes out like this:
"02/03/2010$18""82USPS 35960795520803QPS NEW YORK XXXXXXXXXXXXXX48(Standard Purch)"
With the quotes showing the columns... so the date and half of the price are in one column and the cents from the price and the vendor and the last four digits in the second column.
I'm getting tons of issues opening, saving, and editing files in Microsoft Excel. My checkbook is basically unrecoverable. Files saved give errors that they are read only or the same name as a read only file, despite not being read only. Opening
Quote: Finance_Spreadsheet.xls cannot be accessed. The file may be read only or you may be trying to access a read-only location. Or the server the document is stored on may not be responding......
Is there a way to do this ? When I try to open any file that is password protected, I get an error that the file 'in an incompatible format' (if memory serves, I'm away from my Mac right now). I can open it fine in NeoOffice, but it never works in Number '08. I'd consider going to iWork '09 if the problem has been addressed there.
I might be asking for something that already been discussed on here but I can't find it. I need to find a program preferably free. I need to convert itunes m4v files to non-drm mp4 files.
Anyone know how to convert an AVI, MPG, DiVX or XViD file to a DVD burnable format (VIDEO_TS). I've found several applications that will do this on a PC, but I can't seem to find any that will run on MAC OSX.
I work in a cross platform environment (windows/mac) where we typically save common files to a shared network drive. I've found when I save a file directly from excel (as opposed to saving it locally, then copying it over) it created an invisible ._filename file in the same directory. I know it's a property/resource file for the file that I just created, but it's a little confusing for some windows users and just clutters up the share directory. Is there any way to prevent the creation of the ._filename file while still saving directly from excel?
(I'd prefer not to save locally, then move to network drive - it's cleaner for me if I can just save directly) So far, I've found that this only happens with MS Office. I've opened a sql file in textwrangler and komodo, edited it, and saved it to the network and no invisible files are created.
NOTE: this is different the the fix that apple had published regarding not creating DS_Store files - that refers to copying files from the finder to a network drive and I don't have any problems with that.
I just want to know if there is any way (formula) to count the numbers all the cells which are not empty in a column or row disregarding the content of the cell.
It may contain date, text or even number. I don't want to have the sum of those numbers, rather how many cells, have something in them.
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 handbrake, but want something that will allow me to convert any of my video files to avi or mpeg-2, these seem to stream a bit better and want to convert all to mainly avi, but something with a bit more options would be better. Mac only no windows apps!
Is there a way to automatically save "pages" files in word.doc format, or do you have to do it manually each time? I sure can't find a setting to do what I want.
I'm new to iworks and have trying to figure this one out for a while. I used a template to set up financial info and calculate how much was spent on items. This was the preset formula: =SUMIF(Transactions :: $Category,A2,Transactions :: Amount)
However, I only want the sum from a particular range of dates (e.g. 9/1/09 to 9/30/09, as in cells B2:B10) so I can budget accordingly. In excel, you just grab the highlighted corner and drag it to where you want- here I can't do that and it won't let me add any more "conditions". Any idea how to remedy this? It's driving me nuts. On a side note, I am NOT a programmer so programming language will unfortunately not help unless you get VERY specific about how to do it (which you probably don't want to do).
In Numbers '08, is it possible to link cells/columns between sheets; so that in the below spreadsheet selecting an item from Column A in "Hub Dimensions" sheet in the drop down box of the "Spoke Calculator" sheet would fill out the cells in Column D of the "Spoke Calculator" sheet with data from the related cells in the "Hub Dimensions" sheet?
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
I've seen lots of threads go by about importing e-mail from one program to another, and my case is seemingly simpler, but I have had no luck so far.
I want to import into Entourage the e-mail from a backup of the disk. I know how to import mail into Entourage from other e-mail programs and I know how to import mail into Entourage from an archive created by exporting from Entourage, but I cannot figure out how to import from a backup of the folders under the "/Users/(username)/Documents/Microsoft User Data" folder, under which is where Entourage stores mail.
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.
