Question about Microsoft Excel for PC

1 Answer

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- sumit.arora@samsung.com

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 4 Answers

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 ("=").
4) Click on the "Window" menu in the top menu bar.
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

  • Richard Matta 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.

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

5 Answers

How to repair damage excel file


Use Excel Repair Toolbox designed to restore data from corrupted .XLS files. MS Office .XLS file repair software can fix many error.
For more: https://www.xlsrepairtoolbox.com/

Jul 14, 2015 | Microsoft Excel for PC

5 Answers

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

3 Answers

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.
Read something useful herehttp://www.filerepairforum.com/forum/microsoft/microsoft-aa/excel/691-%E2%80%8Bhow-can-i-repair-excel-file
Or use Excel Repair Toolbox http://www.excel.repairtoolbox.com/

Feb 01, 2015 | The Computers & Internet

1 Answer

HOW TO TRANSFER TALLY ACCOUNTS DATA TO EXEL SHEET


HI,

Please follow below step

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

3 Answers

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

8 Answers

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...

1 Answer

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

1 Answer

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

2 Answers

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)...

4 Answers

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. excelexport.jpgIf 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.

excelexport2.jpgThe 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

Not finding what you are looking for?
Microsoft Excel for PC Logo

106 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18346 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...