# Link worksheets In workbook1 in cell b3 I have the formula ='c:\quotes\[q012.xlsm]quote'!\$c\$7 - I would like to ref the file name q012 to a cell in workbook1 (say b2) so that when I enter q015 in b2 the formula in b3 will change accordingly

Posted by on

Hi,
a 6ya expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
Goodluck!

Posted on Jan 02, 2017

it sounds like you are going over the limits of the program these are the specs. I would recommend dividing up the data if you can. or moving it to a database that can act like excel and hold more data.

Posted on Apr 29, 2008

SOURCE: excel formula help

formula for the keys or short curt for excel

Posted on Jul 28, 2008

If I understand correctly the Round function will round up to the nearest tenth for .05 and above and round down for .04 and below. I am not entirely familiar with the use of the rounding function in a spreadsheet but it seems to me that if you can specify to round down ALL hundredths to the nearest tenth and then add .9 you will get the result you want. Or conversely, round up and minus .01. If this is possible you may want to apply the round function in one cell and then use another cell to add/subtract to get your x.x9 as I believe functions are not always applied in left to right order as read but are apllied in a specific hierarchy, in which case the subtraction/addition could be applied before the rounding and be lost. Using separate functions would overcome this.

Posted on Dec 08, 2008

You've got some parenthesis in the wrong place. Try this:
=(86.01*(Log10(B2-B3)))-(70.041*(Log10(B4)))+36.76

Posted on Apr 06, 2009

You need to change the =IF(AND to =IF(OR
Using AND is saying both conditions must be true. Using OR is saying either condition 1 or 2 need to be true

Posted on Apr 16, 2009

×

my-video-file.mp4

×

## Related Questions:

### How do I pull a figure from a spread sheet and add it to another in the same file.....

Are you talking about different worksheets in the same file.
go to the other worksheet then go to the particular cell and press = on keyboard
then use mouse to select the other worksheet from the bottom of the spreadsheet .
Then click on the cell you wish to link and press enter key on keyboard.

https://support.office.com/en-us/article/Insert-or-delete-a-worksheet-19d3d21e-a3b3-4e13-a422-d1f43f1faaf2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2

You can also do this to spreadsheets with different file names by opening both spread sheets in different windows and switching between the windows.

you can also copy just the data by copy whole sheet (click on the square in top left hand and copy and then right click paste special on new worksheet - with values only rather than the original formulas from the spreadsheet

Jan 06, 2017 | The Computers & Internet

### Dear specialists, I've faced with error with BO Report: The excel file is updating every 15 minutes, but since yesterday BO creates corrupted excel file. Status of appropriate schedule:...

Excel unable to read file is able to resolve Excel repair worksheets, fonts, formulas, cells, columns, rows and etc. Software gives back excel data crashed by any reasons: viruses, incorrect actions anti-virus software, hard drive failures. Tool has the compatibility with Windows 98 and higher. Its interface doesn't require special skills and is simple for novices.

### Describe the each part of microsoft excel 2207

Parts of the Excel 2007 Screen

Active Cell In an Excel 2007 worksheet, the cell with the black outline. Data is always entered into the active cell.
Column Letter Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Formula Bar Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Row Number Rows run horizontally in an Excel 2007 worksheet and are identified by a number in therow header.
Sheet Tab Switching between worksheets in an Excel 2007 file is done by clicking on the sheet tab at the bottom of the screen.
Quick Access Toolbar This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.
Office Button Clicking on the Office Button displays a drop down menu containing a number of options, such as open, save, and print. The options in the Office Button menu are very similar to those found under the File menu in previous versions of Excel.
Ribbon The Ribbon is the strip of buttons and icons located above the work area in Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

### Excel 2007: Conditional formatting

did you put the sheet name in your reference? ex =Sheet2!A1 or you can name the cell ranges on the other sheets and use the cell names in your conditional formatting formla.

May 08, 2009 | Microsoft Excel for PC

### Using sumifs formula accross multiple sheets

Here is the syntax: =SUMIF(Sheet2!A1:A3,"> 1", Sheet2!B1:B3)

This says if the cells A1 through A3 in worksheet "Sheet2" are greater than 1 then return the values from worksheet "Sheet2" cells B1 through B3.

Change the worksheet name Sheet2 to your worksheet name and change the cell references to the ones you need.

Apr 17, 2009 | Computers & Internet

### Reference other worksheet in excel

eg if i want to add to numbers
in sheet 1 i have the value 20 in cell B3
in sheet 2 i have the value 10 in cell B4

thus the formula would be:

=sheet1!B3+sheet2!B4

Mar 13, 2008 | Microsoft Excel for PC

### Unsure of correct formula

You can add a reference from the worksheet 1 to all other worksheets

Is it OK?

Mar 08, 2008 | Microsoft Excel for PC

### Exel 2003

You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (!) to the cell reference. In the following example, the AVERAGE worksheet function calculates the average value for the range C1:C10 on the worksheet named Marketing in the same workbook.

Refers to the worksheet named Marketing Refers to the range of cells between C1 and C10, inclusively
1. Click the cell in which you want to enter the formula.
2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) , type = (equal sign).
3. Click the tab for the worksheet to be referenced.
4. Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

### Microsoft Excel

Dear jois you can make a link from one sheet to other sheet by making a hyperlink. When you will click one cell in first sheet it would shift the sheet in the cell you will fix it.

1. Select a cell that contains the external formula
2. Highlight the File path and sheet name in the Formula bar, eg; 'L:\Daves\[Book2.xls]Sheet1'!
3. Push Ctrl+C then push Enter.
4. Select the range of cells you wish to change the reference in and go to Edit>Replace.
5. Select in the Find what box and hold down the Backspace to ensure you do not have a space.
6. Push Ctrl+V.
7. Do the same in the Replace with box and then edit the file path to the new one needed.
8. Click Replace All
if that has helped you please press 'fixya'

Nov 29, 2007 | Microsoft Excel for PC

### EXCEL

It is very useful to learn excel shortcut realy i thank you

Sep 26, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

23 people viewed this question

Level 3 Expert

Level 3 Expert