excel 2007 compatibility mode error Clifty Kentucky

Computer Repair - On Site and In Store *Residential & Commercial *Networking Services *Virus/ Spyware Removal *Operating System Rebuilds *Dialup Service *High Speed Internet *Anywhere You Live - Anywhere You Are Custom Software Programming *Web Design & Hosting *25 Discount on Repairs for WKY Faculty and Students

Spyware Removal

Address 836A US 31W Byp, Bowling Green, KY 42101
Phone (270) 793-0647
Website Link http://www.accessky.net
Hours

excel 2007 compatibility mode error Clifty, Kentucky

Note: The workbook is opened in Compatibility Mode. Bill Benson I tried what you suggested but it made no difference. In Excel 2007, open the workbook that you want to check for compatibility. In the Compatibility Checker, click Find to locate the cells and ranges that fall outside of the row and column limits, select those rows and columns, and then place them within

Luke Murray I found the solution on another website 🙂 You need to create a folder: Put everything related to everything you are going to work on or with, into that It is much easier/cleaner than any other tip I've seen. Anmelden 6 0 Dieses Video gefĂ€llt dir nicht? microsoft-excel-2007 compatibility share|improve this question edited Dec 22 '09 at 14:40 Mehper C.

This absolutely worked for me, and I am super happy! To make the repairs in a new file, click Continue. Any other feedback? Mike Awesome, thank!!!

Click Microsoft Office Button , click Prepare, and then click Run Compatibility Checker. I don't have the option to save as an Excel 2007 doc. Could you supply the group policy setting your IT guys had set ? Anmelden 1 Wird geladen...

How would you help a snapping turtle cross the road? Sajjan: Aug 13, 2012 at 03:34 PM Your document may be protected. Steve This tip is WRONG!!!!!!!!!!!! Thanks for your detective work..

Click OK to save your changes and exit the workbook. To cancel saving the file, click Cancel. share|improve this answer answered Dec 14 '09 at 19:45 William Hilsum 100k12142233 thanks. The file also needs to be accessed by other people in the office that have an older Excel version.

Anmelden Transkript Statistik 9.432 Aufrufe 5 Dieses Video gefĂ€llt dir? Ashish Sharma Great… It really worked. Also, rather than using the current XML-based file format (.xlsx), the workbook is saved in Excel 97-2003 file format (.xls), a binary file format that is easily opened in an earlier And does not retain whatever you set there.

If you no longer want to work in Compatibility Mode, you can convert the workbook to the current file format. I'm not sure if it's a group policy or local setting but when I do a ‘Run As' for Excel and use a different user account that has never logged onto Top of Page Use file converters in earlier versions of Excel to open an Excel 2007 workbook Specific updates and file converters are available on Microsoft Office Online that can help See Check a workbook for compatibility with earlier versions of Excel to learn how to use the Compatibility Checker.

Susan Snyder I am also have the same issue. This of course comes after completely blowing away my profile and recreating it on my laptop… Gehan Thank you very much for this useful tip which worked for me. Top of Page Convert a workbook to Excel 2007 file format When you open a workbook that was created in an earlier version of Excel, and you no longer plan for Susan Snyder THanks for the info back.

After talking to the IT guys I was able to have them change this for me since there was no reason. Any help would be appreicated. Some cell formats will not be saved. error.

Of course there is a way to do it properly (as others have said above). I put my files on a hard drive to bring them to my new computer. Kategorie Wissenschaft & Technik Lizenz Standard-YouTube-Lizenz Mehr anzeigen Weniger anzeigen Wird geladen... Bill Benson In case not clear, there are such items as Open Open Read Only Open as Copy Open in Protected View as options in the drop-down near Open That would

This means every time excel is opened the rich new features available in Microsoft Excel 2007 and Microsoft Excel 2010 cannot be used, like the number of rows available to use To convert the workbook, you can: Convert the workbook to the current file format    When you convert a workbook, it is replaced with a copy of the workbook in the current file For more information, see:Display numbers as dates or times This workbook contains dates in a calendar format that is not supported by the selected file format. Schließen Ja, ich möchte sie behalten RĂŒckgĂ€ngig machen Schließen Dieses Video ist nicht verfĂŒgbar.

Learn more You're viewing YouTube in German. The Compatibility Checker finds any potential compatibility issues and helps you create a report so that you can resolve them. HinzufĂŒgen Möchtest du dieses Video spĂ€ter noch einmal ansehen? This workbook contains worksheets that have even page or first page headers and footers.

Unless you're using some of the more advanced features you might be able to get away w/o the 2010 features so that your colleagues can collaborate with you using their versions only thing is that i found that i also have an office12 and office14.