Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
My formulas stopped working even though equations are correct | Excel Discussion (Misc queries) | |||
Formulas Stopped Working | Excel Discussion (Misc queries) | |||
Linked Formulas have stopped working! | Excel Worksheet Functions | |||
formulas have stopped working automatically | Excel Discussion (Misc queries) | |||
why formulas have stopped working in Excel? | Excel Worksheet Functions |