Tag Archives: MS Office

fixed : where are my Office 2011 AutoRecovery files ?

Posted on by
167

UPDATE : the updated version of this post for Office 2016 / Office 365 (Word 15 / PowerPoint 15 / Excel 15) can be found here :

fixed : where are my Office 365 AutoRecovery files ?

Question :

I accidentally messed up the Office documents (Word/PowerPoint/Excel) I was working on, and I didn’t save it before, so I wanted to get the auto-saved version from the AutoRecovery-folder as I’ve done before in Office 2008 and 2004.

I forgot where to find the AutoRecovery-folder, so I used Office 2011’s build-in Help-option to get a hint. It told me I would be able to find the folder via this path :

~/Users/username/Documents/Microsoft User Data/Office 2011 AutoRecovery

But when I open that folder I have a “Office 2004 AutoRecovery” and a “Office 2008 AutoRecovery”-folder, but there’s no such folder for Office 2011…

I checked in the Office 2011 Preferences to make sure Auto-saving is switched on, and it is… so where did the folder go ? where are my auto-save documents ?

 

Answer :

You might have guessed : there’s a fault in the Office 2011 Help file. Nowadays, the AutoRecovery-folder is located in an entirely different location on your Mac. The correct path is this :

~/Users/username/Library/Application Support/Microsoft/Office/Office 2011 AutoRecovery

But there is yet another tiny hurdle to get to it : in the current version of OSX, the user’s Library-folder is a hidden folder. So if you want to access it, the easiest way to do so is :

– in the Finder, click on “Go” in the top menu bar

– when the pulldown menu appears, press the ALT-key on your keyboard (a.k.a. OPTION-key) and an extra option named “Library” will appear in the pulldown menu

– while holding the ALT-key, click on “Library” and your personal (hidden) Library-folder will open in the Finder

– there you can navigate to Application Support–>Microsoft–>Office to find the “Office 2011 AutoRecovery”-folder you are looking for

That’s it.

Enjoy !

😉

Note : It is not clear if this problem is due to OSX 10.9 “Mavericks” or that it is occurring with all installations of Office 2011 for Mac. Either way, the solution is as mentioned above.

UPDATE :

it turns out that there’s a bug in Excel 2011 for Mac : even though the Autosave does save  a file with an .xlsx file extension, it’s not a true .xlsx file ! trying to open it will lead to an “Microsoft cannot open this file”-error. The solution is to change the file extension to either .xlsb (Excel binary format) or .xlb (older Excel backup format), to enable Excel to recognize the file and enable it to open.

[ a big Thank You to Paul Preston for noticing this problem and for Bryan P for posting the solution on Superuser.com ]

Donate Button (MacManusNL)

fixed : PowerPoint presentation too large for eMail

Posted on by
Reply

Question :

I just made a beautiful PowerPoint presentation which I want to eMail to my friend. When I tried to eMail it, that seemed to work okay at first, but a few moments later I got an error message saying that the eMail could not be sent.

How can I fix this ?

 

Answer :

eMail providers have set a limit to the attachments’ file size per eMail to prevent cluttering the eMail traffic and flooding the recipient’s eMail inbox. For most providers this limit is set to about 5MB of attached files per eMail message. Some providers have expanded this limit to 10MB, and providers like Gmail, Hotmail and Yahoo! even allow you to attach up to 25MB of files to each eMail.

But if your PowerPoint presentation is even larger than 25MB (which might easily occur if you have done your best to make it a beautiful presentation), you will probably do the recipient  a pleasure if you send a smaller file, especially if they are planning on viewing it on a mobile device. The easiest way to ‘shrink’ the size of a presentation is to convert it into a PDF-file. (a PDF-file is even more versatile than a PowerPoint-presentation, as it also can be viewed by people that don’t have PowerPoint software installed)

To convert your PowerPoint-presentation into a PDF-file, do this :

In MacOSX :

– open your presentation in PowerPoint

– then go to “File” in the upper menu bar and select “Print” from the pulldown menu that appears

– in the “Print” menu that appears, adjust everything as desired, then click on the “PDF” button (bottom left)

– in the pulldown menu that appears, choose “Mail PDF” and a new eMail message will be made for you including your Presentation as an attachment

…or you can choose “Save as PDF…” to first save the PDF-version of your presentation to your Mac so you can attach it to any eMail later on

Note : the above procedure also works in other OSX programs like Word, Excel, Pages, Numbers, Keynote, etc.

For Windows users, the general idea is similar but slightly different :

http://office.microsoft.com/en-001/powerpoint-help/save-as-pdf-HA010064992.aspx

If the standard conversion of your PowerPoint into a PDF still turns up with a PDF-file that is too large to eMail, you can adjust the conversion settings, as described here :

How to create even smaller PDFs in OSX

You might also want to try the “Reduce File Size” that is in the “File”-tab of each Office 2011 application (so in Word, PowerPoint and Excel). This option will only reduce the size of the pictures inside the document. The smallest this option can reduce to is 96ppi a.k.a. “Best for sending in e-mail”. This is an interesting option, but converting to PDF usually leads to even more file size reduction.

And if the recipient insists on getting the original PowerPoint-file, you could do as a lot of professionals do, and send your presentation trough the FREE WeTransfer service :

http://www.wetransfer.com

that’s it !

enjoy !

😉

Donate Button (MacManusNL)

fixed : hashtags making text unreadable in Excel

Posted on by
Reply

Question :

Somebody sent me an Excel spreadsheet in which some of the data is unreadable since it has been replaced by text consisting of hashtag signs only…

I’ve seen this happening before, and the remedy used to be just to broaden the column, since all number that are too large to fit their cell width are automatically made unreadable…

However, in this case, if I broaden the column width, some of the hashtag text will turned into readable numbers, but other hashtag text will remain, no matter how wide I make the column…

What is wrong ?

And how can I fix this ?

 

Answer :

This seems to be a problem with Excel for Windows files that are opened in Excel for Mac (possibly more specifically with data copied or converted from another application into Excel on a Windows-PC). So PC-users will not be warned on forehand that their Excel output is not suited for use on Macs…

Fixing it turns out to be rather simple (but annoying) :

• open the file in Excel for Mac

• select the cells that are effected (or preferably even the entire column), then go to “Format” in the top menu bar

• from the dropdown-menu that appears, select “Cells…” and a window entitled “Format Cells” will open

• make sure the “Number”-tab is selected and make sure that you select “Number” or “General” from the list (make sure that it is something else than what was previously selected ; anything seems to be okay, as long as it is not “Accounting”)

• no return to your spreadsheet to check if the hashtag texts have disappeared (if not : try again)

That’s it !

Enjoy !

😉

Donate Button (MacManusNL)

fixed : copied Excel data only shows zeros instead of original values

Posted on by
Reply

Question :

I have this data-range in MS Excel that I want to copy from one page to another, but when I do, in the area that I want to copy to, all cells are filled with zeros…

…the original data has disappeared…

How can I fix this ?

Answer :

Just use the “Paste Special”-option from the Edit-menu, like this :

– in MS Excel, go to the data that you want to copy

– select the range of data you want to copy

– press CMD + C (or choose “Copy” from the Edit-menu)

– then go to the area you want to copy the data to, and select the upper-left cell of the area you want the copied data to appear in

–  then press SHIFT + CMD + V (or choose “Paste Special” from the Edit-menu)

– in the pop-up window that appears, select “Values” (the option third from the top) instead of “All” (which was the first option from the top), and click “OK”

– now the original data will appear

…that’s it !

Enjoy ! 😉

Donate Button (all)

fixed : copy a row into a column (or a column into a row) in MS Excel

Posted on by
Reply

Question :

I have this column full of data in MS Office’s Excel, and now I need the exact same data range in another spreadsheet, but this time as a row…

Do I really need to re-type all data ?

Isn’t there an easier solution ?

Answer :

Yes, there is a far simpler way to copy data from a row into a column (and vice versa) in Excel.

You can just copy & paste, or “Paste Special” to be exact… it goes like this :

– in Excel, select the range of cells you want to use (or copy)

– then press the CMD + C key-combo (or select “Copy” from the Edit-menu)

– then go to the page (a.k.a. “sheet”) you want the copy the data to, and select the upper-left cell of the area you want the copied data to appear in

– then press the SHIFT + CMD + V key-combo (or select “Paste Special” from the Edit-menu)

– …and in pop-up window that opens, put a check-mark in front of “Transpose” and click “OK”

– now the data from your original row (or column) will ‘magically’ appear as a column (or row)…

…that’s it !

enjoy ! 😉

Donate Button (all)

fixed : use unsupported scanner in OSX 10.8 Mountain Lion

Posted on by
111

UPDATE : a list of supported scanners for OSX 10.9 Mavericks can be found here

UPDATE : Mattias Ellert has now updated the TWAIN SANE drivers, so there is a new version for OSX 10.9 Mavericks (and OSX 10.8 Mountain Lion), more on this can be found here

———————————

Question :

I have a Canon CanoScan LiDE 20 that used to work perfectly in MacOSX 10.6 Snow Leopard. But now I’ve bought a new Mac which runs OSX 10.8 Mountain Lion, I can’t seem to install it, since Canon doesn’t update the drivers anymore.

What can I do ?

Answer :

In OSX 10.7 Lion and 10.8 Mountain Lion any TWAIN-supporting scanner can be used without any additional software :

– connect your scanner directly to your Mac using a USB-cable

– open the System Preferences

– then click on “Print & Scan”

– then, just below in the list of printers on the left, click on the “+”-sign

– that will bring up the “Add”-window, which enables you to add a new printer or scanner

– if your scanner is TWAIN-supporting, it will show up there, and you just need to select it and click on the “Add”-button

– then it will be listed in the previous (“Print & Scan”) System Preferences window, and if you select it (and you put a piece of paper or a photo in the scanner), a Scanning Preview window will show up, allowing you to scan your document to file or eMail or something else…

but…

…some for some printers, like the Canon CanoScan LiDE 20 and LiDE 30, the TWAIN-drivers are not included in OSX. In that case, you will need to install some generic (FREE) TWAIN-drivers :

– for OSX 10.8 Mountain Lion, download and install these files (in this same order) and restart your Mac after doing so, then your scanner will also show up in the “Print & Scan” System Preferences :

libusb.pkg.tar.gz

sane-backends.pkg.tar.gz

SANE-Preference-Pane.pkg.tar.gz

TWAIN-SANE-Interface.pkg.tar.gz

– for MacOSX 10.7 Lion, download and install these files (in this same order) and restart your Mac after doing so, then your scanner will also show up in the “Print & Scan” System Preferences :

libusb.pkg.tar.gz

sane-backends.pkg.tar.gz

SANE-Preference-Pane.pkg.tar.gz

TWAIN-SANE-Interface.pkg.tar.gz

– if these files do not turn into regular .pkg-files when you click on them, you need unTAR-software like this :

The Unarchiver

– if you get an error-message telling you you can’t install this software (these drivers) since the are not from Apple-appoved developers, you need to :

– open the System Preferences

– then click on “Security & Privacy”

– then make sure the “General”-tab is selected

– click the padlock in the lower left corner and provide an Administrator name & password to unlock the padlock

– then at “Allow applications downloaded from:” select “Anywhere”

– and exit the System Preferences to make this setting stick

Note #1 :

TWAIN-supporting drivers (like SANE and the ones that come with OSX) will enable you to directly scan from within various applications like Photoshop, MS Word, GraphicConverter, OmniPage and OSX’s built-in Image Capture.

Note #2 :

when using the SANE drivers, you will probably not be able to use the ‘one click’-buttons that are on the scanner itself…

Note #3 :

if your scanner lets you scan the first time, but after shut-down and restart scanning seems impossible because OSX can’t find the scanner, just plug-out the scanner’s USB-cable and plug it back in and everything should work again…

Note #4 :

if the “Scan”-button remains grayed-out, make sure that you have selected an area to scan… (put differently : if “Selection:” is set to “Off”, you will need to select an area to scan before the “Scan”-button will be ready to use…)

Note #5 :

if you get a distorted scan when scanning in landscape view (or any other rotated view), just scan normally in portrait view and rotate the scanned image afterwards (in Preview app or another image editing program, like Photoshop or Graphic Converter)

Note #6 :

if you are not able to scan as a JPEG (.jpg-flie), just scan as a TIFF (.tif-file) and convert the scanned image afterwards (in Preview app or another image editing program, like Photoshop or Graphic Converter)

Credits :

Matias Ellert and the Open Source developers of the SANE project

Donate Button (all)

fixed : export contacts database from AddressBook to Excel

Posted on by
Reply

Question [1] : I’m new to Mac, I just switched to my first Mac, before I only used Windows PCs. How can I import my contacts from my Windows PC into my new Mac running OSX ?

Question [2] : I’m a Mac user myself, but I need to share my contacts database from Apple AddressBook with WindowsPC-users I’m working with. Since there is no Apple AddressBook for Windows, this seems impossible. What can I do ?

Answer to both [1] and [2] : It’s possible, and it isn’t that complicated either.

There are (free) MacOSX-applications that can do this for you.

! BEWARE ! there are 2 applications around that are extremely similar (and therefore easily confused) both in name and features :

Address Book Exporter 2.1.2 (from 2003 ; with a space in the name)

http://www.macupdate.com/info.php/id/9312/address-book-exporter

AddressBook Exporter 1.0 (from 2005 ; without a space in the name)

http://www.macupdate.com/info.php/id/17501/addressbook-exporter

The first one (from 2003 ; with a space in the name) is the best one. That’s the one that still works properly with Apple AddressBook from MacOSX 10.6 “Snow Leopard”.

How to install :

  • download the application (from 2003 ; with the space in the name)

http://www.macupdate.com/info.php/id/9312/address-book-exporter

  • drag the application-icon to your Applications folder

How to use it :

  • startup the application “Address Book Exporter 2.1.2”
  • from the “Groups” list, choose “All” to start converting your entire AddressBook, or choose only the selection that you want to export
  • if you would like to convert / export a selection that is not listed, go back into your AddressBook and create a (temporary) group from your selection
  • now, in “Address Book Exporter 2.1.2” check the checkbox of “Export using current field settings”
  • click the “Configure Settings” button
  • in the pull-down menu that appears, check the checkboxes of everything that you would like to export, and click “OK”
  • click the “Export Address Book” button
  • if you like, you can change the name of the exported file
  • then choose a destination on your Mac where you will be able to easily find the exported file (e.g. “Desktop”) and click “Save”
  • quit “Address Book Exporter”
  • open “MS Excel”
  • drag the icon of the exported file (from the Desktop) onto the MS Excel icon in the Dock, to have it opened in Excel
  • and… here you are : all your contacts are in Excel now
  • from there you can “Save As” to have a .xls-file that you can share with WindowsPC-users