Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 05-12-2014, 08:02 AM
BobBridges's Avatar
BobBridges BobBridges is offline Sum values within a single cell Windows 7 64bit Sum values within a single cell Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

In the old versions of Excel, up to 2003, workbooks were named .xls and macros were stored directly in the workbooks. But with increasing concern about malicious software, Microsoft introduced a distinction between workbooks that can contain VBA code and those that can't. The plain-vanilla workbook is now .xlsx. If you want to write a macro for one of your workbooks, it won't be saved in an .xlsx; you have to store it with extension .xlsm. This provides a little extra warning about the content to a user opening a workbook, in addition to the warnings that pop up.

I graduated straight from 2003 to 2010, so I don't know whether this distinction started with 2007 or 2010.

Does that help? If I skipped over an important part of the explanation, feel free to keep asking.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum values within a single cell Summing up values in a Single Merge Field Beowolf Mail Merge 1 03-07-2014 03:26 PM
Finding Earned Values for Different Baselines in a single project pratik6312 Project 1 08-22-2013 11:18 AM
Sum values within a single cell How to count multiple values in a single cell, except zero? iuliandonici Excel 1 04-13-2011 09:45 PM
Sum values within a single cell Sum & difference between multiple values in a single cell iuliandonici Excel 4 04-13-2011 09:27 PM
Sum values within a single cell How can I write the following (whole) formula in a single cell? Learner7 Excel 1 07-19-2010 10:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2026 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft