Question about Microsoft Excel for PC

# EXCEL2000 PROBLEM SIR, I HAVE TWO FILE IN EXCEL (A.XLX, B.XLS), BOTH ARE IN SAME DATA . BUT IF I WANT TO CHANGE A.XLS (SHEET) , THEN AUTOMATICALLY B.XLS DATA MUST BE CHANGE. PLEASE SOLVE MY PROBLEM AS SOON AS POSSIBLE. THANKS AND REGARDS SUMIT ARORA EMAIL ID- [email protected]

Posted by on

### Anonymous

• Level 1:

An expert who has achieved level 1.

• Contributor

I think I have a way for you to get this done. Open a.xls and then open b.xls. In b.xls, create a formula in any cell that you want to be updated based on the data in a.xls. For example, if you want cell A1 in b.xls to stay updated with the data from cell A1 in a.xls, your formula in A1 of b.xls would look as follows:
[a.xls]Sheet1!\$A\$1

You can also create such formulas by following these steps:
1) Open a.xls and then open b.xls.
2) Place your cursor in the cell that you want to update dynamically in b.xls.
3) Enter the equals sign ("=").
5) Select a.xls from the bottom of the menu items in the Window menu.
6) Click on the cell that contains the data that you want.
7) Hit Enter.
If you do all of these steps, you should find yourself back in b.xls with Excel having created the right formula for you. As a test, you can switch to a.xls and make a change in the source cell, and then you should be able to switch back to b.xls and see that same update.

Good Luck, hope this meets your need!
Regards,
RichMTech

Posted on Aug 08, 2008

• Anonymous Aug 09, 2008

Let me clarify the formula in the first paragraph. Technically, your formula would start with an equals sign ("=") like all formulas do in Excel, so the contents of the cell in b.xls would be: =[a.xls]Sheet1!\$A\$1.

In any case, the other way of doing it that I described in the steps is easier.

×

×

my-video-file.mp4

×

## Related Questions:

### How do i recover my corrupted MS Excel File ....???

Using proper locations to keep your office documents and making regular backups are great preventive measures against data loss. If you've lost a document or the whole bunch of them, do not despair. Modern data recovery tools can reliably detect, locate and restore documents even if they are stored on a badly damaged, corrupted, formatted or repartitioned hard drive or other storage media.

Use Hetman Office Recovery for recovering your corrupted MS Excel file: https://hetmanrecovery.com/recover_deleted_document/office-software.htm

Oct 17, 2016 | Computers & Internet

### How to repair and recover corrupt MS excel file? I am unable to open corrupt MS Excel file due to virus infected, I have crucial Workbook sheet got lost, so how to get back corrupted MS Excel file. Please...

Excel file can be repaired manually if it is less corrupted but Open and Repair program doesn't work if highly damaged due to corruptions. I searched for solutions to repair corrupt Excel file and found one solution which is full of information and provides a guaranteed solution. I am sharing this solution with all the users -Excel Repair Toolbox. Follow the exact steps given in this programm and you will be able to access the data. Download Microsoft Excel Repair tool

May 24, 2015 | Microsoft Excel for PC

### How do i fix corrupted excel file?

It's a critical problem for us, after unfortunately data file got corrupt due to virus infection, I faced such type problem.
Or use Excel Repair Toolbox http://www.excel.repairtoolbox.com/

Feb 01, 2015 | The Computers & Internet

### HOW TO TRANSFER TALLY ACCOUNTS DATA TO EXEL SHEET

HI,

Step 1. Open Tally

Step 2. Open Report Which is you want Transfer in Excel.

Step 3. Press CTRL With E (Ctrl+e) from keyboad

Step 4. Select Sharped Sheet or Excel

Step 5. After type location for file save like this D:/your folder name/

Step 6. After You type file name with xls. like this sales.xls

thanking you

davevipul197

Dec 19, 2010 | Computers & Internet

### Export tally data to excel

tally data to excel converting . i have some data export to excel but no excel formating you have some tally data to excel spred sheet software

Aug 27, 2009 | Tally T2245 Matrix Printer

### Repair corrupt excel file

Don\'t need to worry even if your excel
files are get corrupt because there are several ways to repair
corrupt excel files. The easiest available solution is to use "Open
and repair" utility of MS excel to repair damaged xlsx or xls files.

Jul 10, 2009 | Microsoft Office 2003 Professional Full...

### Sir help me: im not able to open my excel files directly,i need to open of one sheet of excel before i open the files,please help me in my case... thanks and more power!!

There might be a problem with you file association for '.xls'.

You can check this from Windows Explorer, on the menu bar choose Tools >> Folder Options... >> then select the 'File Types' tab.
Look to see if Excel is the default program to open the '.xls' file. At the bottom portion of the window, it shows 'Details for...' and 'Opens with'. Just associate it with Excel.

**Note: This may not be possible if you are NOT the administrator of your PC system.

Hope this helps.

Jul 03, 2009 | Computers & Internet

### I have some value in Sheet2 of an xls file. now i want to link that value to a cell in Sheet1. Hence, if theres any change of value in sheet2 it also do reflect in Sheet1

Just put the following formula in the cell you want the number to change.
=sheet2!b1 the B1 is the cell on sheet 2 or whatever cell you want to link to. Whatever you put in cell B1 on sheet 2 will automatically change on the cell on sheet one you place this formula in.

Apr 24, 2009 | Microsoft Excel 2003 (065-03992) for PC

### Windows excel file can't open

From Excel, try clicking on the 'down' arrow in the 'Open' button, then select, "Open and Repair," then select the file.

Nov 27, 2008 | Microsoft Office Access 2003 (077-02871)...

### How can i export tally data to excel format?

Export to Excel With new release now you would get one more options while exporting data. One added format option is Excel format. If you export in this format then file would be saved in xls format. More over if you put Excel formating option to Yes then tally would automatically format the data in presentable format. Tally would automatically bold the headlines and main fields for you and format data in a good way. Take a look at excel snapshot of balance sheet exported from Tally.

The special thing here is that you can do the calculation on any amount figure or any row or column, which was earlier not possible. The only drawback which i could find was that amount figures are not right aligned which is must for numbers for easy calculation, although you can do it by selecting the amount figures and putting them right aligned.

Feb 27, 2008 | Computers & Internet

## Open Questions:

#### Related Topics:

113 people viewed this question

Level 3 Expert

Level 3 Expert