Excel 2007 Notes and Help
Excel 2007 is known as version 12 so you
can Id if the version is 2007 or not.
|
|
Excel 2007 Notes and Help |
Interactive: Excel 2003 to Excel 2007 command reference
guide:
http://office.microsoft.com/en-us/excel/HA101491511033.aspx
Excel 2007 Command Mapped (from older versions of Excel)
My office has converted us all to Excel 2007. where can I get
a map that shows where the old Excel
commands are to be found in the new "user friendly" 2007?
Firstly, it's actually built in - search help for What's New
and you'll find where commands are from Excel 2003. If you want more details
please see one of the following links
http://www.mrexcel.com/excel2007tipcard.html
http://officebeta.iponet.net
http://www.mrexcel.com/excel20
One way to find ANY command's location is to right-click a
command, choose "Customize Quick Access Toolbar", in the first dropdown, change
to All commands, find your command alphabetically
(thanks to Bob Umlas)
Excel 2007 running slow?
Make sure you have disabled the Google Office COM addin: this
can significantly slow down XL2007
http://www.asap-utilities.com
Other things to consider:
Use VBA code to Turn of screen updating if running code
Turn off automatic calculation
Consider investing in "Fast Excel" by Charles Williams to learn how to speed Excel up
Consider using arrays if loading or moving large datasets.
Why wont the macro recorder work when I try to record
creating a chart in XL 2007?
Simple reason, Microsoft broke it. The macro recorder does
not function fully as expected in Excel 2007.
Hate the Ribbon? Want to install Classic
2003 Menus in Excel?
Thank god for 3rd party modders who are smarter than me!
Here are three of the best I have found so far, in no particular order or
preference.
MenuExcel
http://www.addintools.com/english/menuexcel/
Tooolbar Toggle
http://www.toolbartoggle.com
XL Menu 2003
http://in.geocities.com/shahshaileshs/
Macro Not Found Error - Excel 2007
A user has bought a new laptop with Vista and XL 2007.
From a thumb drive the user has no problem using my XL application on a older
laptop running XL2003 under XP, but when trying to use the application on the
new laptop they get a Macro Not Found Error. Is there a setting or
something with Vista/2007 that needs tweaking?
This is normally caused by a security setting in Excel 2007: This site link
below may assist you with helping the user check macro
security setting in Excel 2007. http://office.microsoft.com/
(Thanks to Simon Bamber - Excel-L list)