I'm not very practiced in Excel other than the basics. I just took over an Excel document that's used for scheduling about 50 people in various locations in various times of the day. This schedules changes every day. The document has two tabs for every day of the week. One is a sheet that's color-coded and used for schedulers to work on, the second is a sheet that refers to all the cells in the colored sheet but it's formatted more clearly and used strictly for printing and posting to employees.
My problem - one of them - is that I am trying to work on the document at home. I emailed it from my work PC and downloaded it onto my Mac. I'm running Excel 2003 at work, Excel 2008 at home on the Mac - but I always save the document in .xls (Excel 27-2004) format.
So when I open the document at home, I get errors that most of the cells are referring to a "closed workbook." I feel like this is a stupid question - but I've searched in books and online for this - What exactly does that mean? What IS a closed workbook? And how do I make it "open?" If I'm copying the whole file from work, with all tabs included - how/why is it wanting to refer to some "closed workbook?"
Is there some setting I can deactivate on the file at work before I email it to myself, or if I install Windows/MS Office 2003 onto my home computer - will that get rid of the error? I don't feel like the problem is PC/Mac compatibility but I don't really know what to do or try.
My problem - one of them - is that I am trying to work on the document at home. I emailed it from my work PC and downloaded it onto my Mac. I'm running Excel 2003 at work, Excel 2008 at home on the Mac - but I always save the document in .xls (Excel 27-2004) format.
So when I open the document at home, I get errors that most of the cells are referring to a "closed workbook." I feel like this is a stupid question - but I've searched in books and online for this - What exactly does that mean? What IS a closed workbook? And how do I make it "open?" If I'm copying the whole file from work, with all tabs included - how/why is it wanting to refer to some "closed workbook?"
Is there some setting I can deactivate on the file at work before I email it to myself, or if I install Windows/MS Office 2003 onto my home computer - will that get rid of the error? I don't feel like the problem is PC/Mac compatibility but I don't really know what to do or try.
