Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Bizarre Behavior referencing a sheet.
The excel file that I'm working with is called:
performance summary f00-w03 It has multiple sheets, like f00, w00, s00, f01,..., w03 All of the cells' values are based on formulas, like the following in the formula bar: ='ACE Program Assistant:Documents:reports:performance data:qtrly workbooks copy415:[f00 performance datac]bio20b'!Y29+'ACE Program Assistant:Documents:reports:performance data:qtrly workbooks copy415:[f00 performance datac]bio20c'!Y29 I'm working with Microsoft Excel X MAC version. My machine name is 'ACE Program assistant'. My understanding of all of this is that the file being referenced is called "qtrly workbooks copy415" sitting in the folder "performance data" under "reports", etc. The problem is that under the "reports" folder there is no "performance data" folder or excel book called "qtrly workbooks copy415" But somehow the sheet just calculates a value based on that formula and it prints out 14 in the cell. Could it be that the file is hidden? Well I copied the offending formula, placed it in another file in a separate computer diconnected from the network and the darn formula still works! why isn't the formula complaining that the file is not there? How can I figure out what's wrong? If I reference another file say: " ='ACE Program Assistant:Documents:reports:whatever:[Sheet1]bio20b'!Y29 then it complains. But not with Copy415. Why? Somebody please help. Thanks, David |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bizarre Behavior referencing a sheet.
Thanks J.E.
But, how can I refresh all of the values, so that if the file that it references does not exist, I should get the !REF. Right now it is using values that are cached. Even after I get the prompt The workbook you opened contains automatic links to information in other workbooks. Do you want to update this workbook with .....? After I click YES, the same old information is displayed. can I erase the cache that Excel uses or whatever it is that it pulls information from? thanks, David *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bizarre Custom Views behavior | Excel Worksheet Functions | |||
Odd behavior from Protected Sheet | Excel Discussion (Misc queries) | |||
Bizarre behavior in VLOOKUP function | Excel Worksheet Functions | |||
odd behavior when referencing a cell on another sheet | Excel Discussion (Misc queries) | |||
Bizarre Behavior in Excel | Excel Discussion (Misc queries) |