Please Please Help! I need a solution ASAP!
Posted by Anna Daly on December 04, 2000 2:37 PM
I have a big problem with a spreadsheet that I am due to give someone today!
The problem is that I have formulas in cells that reference a worksheet. However the worksheet that they reference is imported into the workbook with some VBA code. The error that I am getting is the REF! error in the formulas that refer to the imported spreadsheet. This I know is due because Excel is trying to calculate the formulas before the sheet exsists. I cannot stop Excel from trying to do this. I have tryed turning the calculate sheet to manual and then turning it back to automatic once the sheet has been imported , but this does not seem to work. Any ideas plese. Your help will be very very greatfully received.
The kindest regards