Can you tell the steps to remove the file path that shows whose computer the Excel 2010 workbook resides on and its file path. This is showing on the FILE TAB at very top of page right under where it says "INFORMATION ABOUT XYZ" (where XYZ is file name). Also, under "Related dates" on Info Tab, is there a way to get ride of LAST MODIFIED: time and "CREATED" time? I removed all other personal data with Inspector but cannot figure out how to remove File Path and the Last Modified and Created time.
SOURCE: Populate a cell based on a specific criteria in Excel
[formula in the new Category Column]
=RIGHT(A1,LEN(A1)-SEARCH(" ",A1,LEN(A1)-11))
Where A1 is the cell that stores the Business names.
SOURCE: Excell workbooks
You need to learn how to use the, "Paste Link," function. If you copy the spreadsheet and paste the information into a new tab in the same workbook, using the 'paste link' feature, the information on the linked pages will update automatically each time you update the page the links are based upon.
SOURCE: File in Excel is password protected
You'll have to download a program that will try and extract the password from the excel file. Passware is the best one I can think of, and can be found at (http://www.lostpassword.com/office.htm). It's a little pricey, but it's the best one i've found, and always gets it right the first time. I think the cost is about $125.00. I can't think of any free ones available.
Steven
SOURCE: need to change text direction
go to your start menu/settings then control panel, when your in there go to regional and language settings and change all the options to uk
let me know how you get on
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.
216 views
Usually answered in minutes!
×