Office Software Thread, Excel External Links in Technical; Why is excel being a pain?
I want to link some cells to another spreadsheet. When create the link for ...
18th September 2009, 06:20 PM #1
Excel External Links
Why is excel being a pain?
I want to link some cells to another spreadsheet. When create the link for the first cell it puts in the cell
=[ReportNamesRaw.xlsx]Sheet1!$A$2 and displays the value from the other workbook.
When I remove the $ signs so that I can fill the formula into the other 1200 cells it changes it to text.
WHY WHY WHY.
Signed: Frustrated of Rotherham.
By imiddleton25 in forum Virtual Learning Platforms
Last Post: 14th October 2008, 10:17 AM
By Diello in forum EduGeek.net Site Problems
Last Post: 2nd June 2008, 04:06 PM
By ranj in forum Wireless Networks
Last Post: 14th March 2008, 07:26 PM
By beeswax in forum Virtual Learning Platforms
Last Post: 14th July 2007, 11:04 PM
By tosca925 in forum General Chat
Last Post: 19th December 2005, 09:31 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)