T
Troutman
I'm a little bit frustrated. I have an excel workbook with a dozen or so tabs
at the bottom. All of the formulas within each tab stopped working. These are
very basic formulas. We are publishers of several weekly newspapers and
magazines. I keep month by month tabs at the bottom of the workbook. So when
I click on the January Tab for instance, all of the publications that
published in January appear by name with the revenue they produced. Each
revenue total is added up and then compared against a budgeted amount similar
to this:
Story County Weekly $18,000
Boone County Weekly $10,000
Star Gazette $ 5,000
Total Revenue: $33,000
Budgeted: $27,000
Variance: $ 6,000
I can alter the numbers in the cells for instance I could change the Star
Gazette to $10,000 but the total remains $33,000. I've tried redoing the
formula using conventional means but the totals still don't change.
The only common thread here is that I store this info on a falsh drive. I
work on a PC in my office and a laptop at home. This weekend I did a day's
worth of work in this workbook and when I brought it into the office and
plugged in the flash drive the workbook opened but I am unable to update it
further (as described above). I store several workbooks on the flashdrive. On
the weekend I opened several of those books just to reference information I
needed for the workbook in question...all of those workbooks are also
disabled. However the other books that resided on the flashdrive that I
didn't open are still functional.
I'm up against it here because I have a deadline to make. Is there a way to
fix this simply? Or do I have to start all over again?
at the bottom. All of the formulas within each tab stopped working. These are
very basic formulas. We are publishers of several weekly newspapers and
magazines. I keep month by month tabs at the bottom of the workbook. So when
I click on the January Tab for instance, all of the publications that
published in January appear by name with the revenue they produced. Each
revenue total is added up and then compared against a budgeted amount similar
to this:
Story County Weekly $18,000
Boone County Weekly $10,000
Star Gazette $ 5,000
Total Revenue: $33,000
Budgeted: $27,000
Variance: $ 6,000
I can alter the numbers in the cells for instance I could change the Star
Gazette to $10,000 but the total remains $33,000. I've tried redoing the
formula using conventional means but the totals still don't change.
The only common thread here is that I store this info on a falsh drive. I
work on a PC in my office and a laptop at home. This weekend I did a day's
worth of work in this workbook and when I brought it into the office and
plugged in the flash drive the workbook opened but I am unable to update it
further (as described above). I store several workbooks on the flashdrive. On
the weekend I opened several of those books just to reference information I
needed for the workbook in question...all of those workbooks are also
disabled. However the other books that resided on the flashdrive that I
didn't open are still functional.
I'm up against it here because I have a deadline to make. Is there a way to
fix this simply? Or do I have to start all over again?