55. Reference Data Outside This SheetBEFORE YOU BEGIN 42 Enter Simple Data into a Spreadsheet 46 Edit Cell Data SEE ALSO 64 Conditionally Format Data If all your data resided in the current sheet, referencing other cells would be simple. You'd only need to know the other cell's address, such as D4 . What if the cell is in another sheet inside the current spreadsheet? If Sheet1 needs to reference cell G6 in a sheet named Sheet3 , you cannot use the simple G6 reference. TIP If you use a spreadsheet with multiple names, consider renaming the default sheet names of Sheet1 , Sheet2 , and Sheet3 to names that are more meaningful, such as Division1Sales , Division2Sales , and Division3Sales . Right-click the sheet name 's tab and select Rename to rename, insert, or delete any sheet. Perhaps the data you need isn't even in another sheet but resides across your network somewhere. Or, perhaps, the data resides across the world, accessible from the Internet. That's no problem for Calc. You can insert network addresses and web address links anywhere in a spreadsheet to display data from that location. 55. Reference Data Outside This Sheet
Use the following pattern: ='http://www.YourDomain.com/Spreadsheet.sxc'#Sheet1.Cell That's quite a mouthful! Here is one such example: ='http://www.simplerenthouses.com/corporate.sxc'#Division1.W11 NOTE Remember that .sxc is the file extension for previous versions of OpenOffice.org spreadsheets. Calc can also reference data from Excel workbooks that use the .xls file type. To read such a long reference, it helps to begin at the right. This references cell W11 in the sheet named Division1 in a spreadsheet named Corporate.sxc on a website named www.SimpleRentHouses.com; keep in mind that you must enclose the web page reference inside single quote marks. Calc adds a dollar sign ( $ ) to your external sheet name to keep it an absolute reference. Also, Calc will rename your web page reference to all lowercase letters if you type any in uppercase. |