I was working with excel sheet for a long ago with my R and Ds suddenly it prompted for a error by mistake i clicked yes, from that time i am not able to put the formulas in any of my excel files unless i change the value and save it.Plz help me.
regards,
chidambar
Before you uninstall Excel, first ensure your formulas are set to automatic.
Go to the Formulas Ribbon.
Calculation Options.
Automatic.
Dear chidambar, thats usually because you've mistakenly tampered with a file or because you're putting an inapplicable value. Can you tell me what error is it exactly ?
you might like to re-install your MS excel after backing up your files. You might also like to repaire your ms office from your cd.
if that has helped you plz press fixya.
Excel Workbook
.xlsx
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
Excel Macro-Enabled
Workbook
.xlsm
Uses the same basic
XML format as the Excel Workbook, but can store VBA macro code. Users saving
an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in
Excel 4.0) are prompted to use this file format.
Excel Template
.xltx
The default file
format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro
sheets (.xlm files in Excel 4.0).
Excel Macro-Enabled
Template
.xltm
Can contain a
VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0).
Workbooks created from this template inherit the VBAProject part or Excel 4.0
macro sheets that exist in the template.
Excel Add-In
.xlam
A supplemental
program that runs additional code. Excel add-ins use the Open XML file format
to store data, and they support using VBA projects and Excel 4.0 macro
sheets.
117 views
Usually answered in minutes!
×