|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
| Notices |
 |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
07-07-2008, 10:28 AM
|
|||
|
|||
Not able to reference a cell outside of worksheet!
I do not know what happened. I am trying to use the = sign or the sumproduct and the program is completely ignoring to write the cell that I am clicking to bring into the worksheet.
Any ideas. 
|
|
#2
07-07-2008, 10:38 AM
|
||||
|
||||
|
Did you add an opening parenthesis too, before clicking on the cell in the other sheet?
e.g. =Sumproduct(...then click cell
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge! Please read the Forum Rules: Rules
|
|
#3
07-07-2008, 11:09 AM
|
|||
|
|||
|
I think I found the error!!!
I am freaking out because I can't do anything until I get this fixed. When I open excel now, it creates a pop alert stating "Error Creating Variable Table!".
|
|
#4
07-07-2008, 11:19 AM
|
||||
|
||||
|
I don't have 2007 so I am not sure what that means...
although I just did a google search on that error and got no returns... Are you sure about the exact wording of the error...
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge! Please read the Forum Rules: Rules
|
|
#5
07-07-2008, 11:50 AM
|
|||
|
|||
|
Now I found an .abi file next to some of my files!
What does that file do and why is it there? Is has the same name as some of my files with the .abi extension.
Please help.
|
|
#6
07-12-2008, 03:08 AM
|
|||
|
|||
|
When you are trying to link cells from another workbook, is that other workbook also a 2007 file? If not, that may be your problem. For instance if you have a 2007 file open that isn't in compatibility mode and try to link to a cell in 2003 or other version, it will not recognize the other file.
http://blogs.msdn.com/excel/archive/...10/694606.aspx http://technet.microsoft.com/en-us/l...chNet.10).aspx Hope that helps.
|
|
| Bookmarks |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
