Thread: Get graphicsdata from different files

Hello,

New user and basic Excel skills. So please help!
I have a 2009 and a 2010 excel file, where I keep track of the revenue per month in my company. Now I want to create a new file with several graphics where I can compare 2009 and 2010. It works for different worksheets, can it be done for different files??

Thanks

Hi,

Please attached some sample data for more details.
So that I can help you.

Rahul

Yes, it can be done with different files. Depending on what the formulas are, the files might need to be opened to use them. Is that acceptable or would you want to be working with closed files?
In general, to refer to a different file, the file name goes in brackets e.g.

Code:

=[test2.xls]Sheet1!A1-[test1.xls]Sheet1!A1

where test1 and test2 are your two other open workbooks. When you close the other two workbooks, your formula will automatically adjust to include the path. (Again, not all formulas work with closed workbooks)

Code:

='\\mydocuments\Home\user\[test2.xls]Sheet1'!A1-'\\mydocuments\Home\user\[test1.xls]Sheet1'!A1

Does that help?

Yes thanks! That doe help. Although, it's not fixed... Apparently one of the two files I wish to use data from is open, and the other is not. So the next question is, how do I make a document "open"?

I just want to make a column chart with data from two different documents...

Thanks for clarifying the first issue!

ADB

So the next question is, how do I make a document "open"?

Maybe:

File - Open - file name ....