Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel: links to UDF on other page go blank during save
I have a spreadsheet that has several cells that have links to a cell located
in a different, (i.e. ='Sheet 3'!AC8). The cell on the different sheet calls a user defined function. When I'm in the first sheet and save the file, those cells that link back to sheet 3 go to zeroes. If I display sheet 3 and then redisplay sheet 1, the cells will contain the correct values, otherwise they will contain zeroes. My UDF called from sheet 3, has Application.Volatile, all Office and OS maint is up to date. Anybody have any guesses as to what I'm doing wrong or where to look? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel crashing on save as | Excel Discussion (Misc queries) | |||
How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) | |||
Getting Excel 2003 to save Custom Toolbars | Excel Discussion (Misc queries) | |||
How do I save a record from an excel template to a database in a . | Excel Discussion (Misc queries) | |||
No Smart Tag help: just a blank "MS Excel Help" window - Excel 2003 | Excel Discussion (Misc queries) |