Question about Computers & Internet
Save the arrangement of those sheets by Clicking View->Save Workspace.Now in future, whenever u open the workspace file the arrangement of those will be unchanged.
Posted on Dec 30, 2013
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
If you mean that you can open the Workbook and read the Worksheet - then all you have to do is select all and paste it to another Worksheet. This will allow for changes of formulas etc.
If you mean the whole Workbook - then I dunno.
In future, either use the same password for everything (easy to remember) or Protect the work with nothing entered into the password field (leave this blank). This last will protect the work from people who try to guess your password, but will be easy for you to remember - eg every password is left blank.
If you must use unique passwords, then keep a record of them somewhere other than on your computer.
Sorry I can't help with the "Workbook" solution - but somebody else out ther may be able to do so.
Posted on Apr 25, 2008
Nope, sorry, although I am truly an expert at Excel formulas, I do not understand what you are trying to end up with in the final cell. We can compare a specified field with two spreadsheets - use named ranges and index/match lookup formulas. But then where you really lose me is in reading "a generic field" to find a match, and then placing what "data from another field" into what "other sheet" - ? See the confusion?
Best way to compare 2 given parameters would be to use a nested if formula, with index/match combo. Here is a simple Excel example of how such a formula could be structured:
Sample Data (columnar arangement):
A1: Part B1: Code C1: Price D1: Find Part E1: Find Code
A2: x B2: 11 C2: 5.00 D2: y E2: 12
A3: x B3: 12 C3: 6.00 D3: y E3: 11
A4: y B4: 11 C4: 7.00 D4: x E4: 12
A5: y B5: 12 C5: 8.00 D5: x E5: 11
To retrieve the price for part y with code 12 and return the value to cell F2, type the following formula in cell F2:
Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00.
To take this one step further, with range names, this example will find one value at a specified location which matches a specific row header value and column header value. Let's say the range is home values (Range=HomeVal), Column A of HomeVal contains street addresses,"row headers" (Range=StAddress), and Row 1 contains dates of the various values that are in the body of the table, "column headers" (Range=Dates). To return the specific value from the range HomeVal to another sheet, where A1=address specified and A2=date specified:
Then make sure to press CTRL+SHIFT+ENTER to enter the formula as an array formula - if you only hit enter, these types of formulas will not work properly.
Please post back if you need further help, with more details, otherwise thank you for using and rating FixYa!
Posted on Jul 08, 2008
SOURCE: my excel sheet is not opening
assuming you have Excel sw on your PC.
Assuming you are running XP.
Assuming you can start your Excel and Open any excel file using File/Open within excel.
You must associate Excel file with Excel program in your Windows Explorer.
Fastest way is Browse to any excel file with your Windows explorer (NOT IE)
Right click and select Open with...
Browse to find your Excel MSOffice program
Select Use always to use this program
Posted on Dec 28, 2008
Tips for a great answer:
Jan 01, 2016 | Microsoft Excel Computers & Internet
Jul 16, 2014 | Microsoft Excel for PC
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
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.
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).
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.
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
Feb 21, 2011 | Computers & Internet
Apr 21, 2010 | Microsoft Windows XP Professional
Apr 12, 2010 | Microsoft Excel for PC
Feb 24, 2010 | Tally T2245 Matrix Printer
Jul 01, 2009 | Computers & Internet
Feb 11, 2009 | Microsoft Excel for PC
37 people viewed this question
Usually answered in minutes!