0
What else can I help you with?
What is a background formula checking in Excel?
Excel continually reviews the workbook for errors in formulas as you create or manipulate it
When you create formulas in one workbook that reference cells in a different workbook you are doing what?
You are linking the two workbooks.
How do you create a macro to open another workbook automatically?
It can be done easily by addingWorksbooks.open Filename:=command in macro.Eg: Workbooks.Open Filename:= _"C:\Documents and Settings\abcabc\My Documents\Company List.xls"If you like to create a particular macro for this purpose, the following lines will be helpful for youSub OpenWorkbook()'' OpenWorkbook Macro' To Open Another workbook automatically''Workbooks.Open Filename:= _"C:\Documents and Settings\ABABC\My Documents\Company List.xls"End SubHope this will solve your issueBalu
When you create a formula that refers to a cell in another workbook where will the source workbooks name appear when you click the cell containing the formula?
It appears at the start of the reference and is enclosed in square brackets. So if you were referencing cell B2 in a workbook called Sales and on a sheet called North, the reference in full would be as follows: =[Sales]North!B2
When a workbook is saved as a template by default it is saved to?
create new folder
What is a special workbook or worksheet you can create and then use as a pattern to create new similar workbooks or worksheets?
A template.
How can you create a macro in Excel that saves the day's income in a workbook and then creates a new workbook every week?
how am i surpose to no?? go on the internet and find out for your self !!
What tool is used to automatically create new formulas based on the first formula typed?
I believe you are referring to a macro. Could also be an IF statement.
How do you create an external reference to a cell into another workbook in excel?
You need to enclose the workbook name in square brackets, then specify the sheet in that workbook and then the particular cell. So if you wanted to refer to cell A10 on Sheet2 of a workbook called Sales.xls then the reference would be like this: =[Sales.xls]Sheet2!A10
How many pivot table can be can be created in the Excel?
You can create as many as you need. However, you are unlikely to need to create many in a workbook.
What is a partially completed workbook that you can use to create other workbooks that have the same structure and purpose?
template
How do you Create Macro on One Workbook and then Let User Choose Location on Another Workbook They Want Macro to Run on?
One way would be to prompt the user to choose a workbook from those currently open (or browse for one that isn't). However, an easier approach is to simply run the macro on the currently active workbook by assigning the macro to a toolbar button.
