I have an excel sheet I use as a budget. I update it daily, prefering to save as excel to whatever PC i'm on at the time, edit it in Excel, and then upload the updated copy back to google docs when I'm done.
I have this really annoying problem though, where after I export the doc from google into an .xls file, the the formula in one row shows an inaccurate sum. I always fix this by simply double clicking the cell, taking me into formula edit mode, and then hitting enter without actually modifying the contents of the cell. The sum immediately shows the proper total. The formula is very simple too, just additions and subtractions of values from different rows within the same column: =K3-K52-K91-K21
After that, i fix the other cells in the row by copying the value from the "fixed" cell and pasting into the other cells.
I was wondering if anyone has experienced the same thing, and/or might know how to prevent this from happening. It's really annoying.
I have this really annoying problem though, where after I export the doc from google into an .xls file, the the formula in one row shows an inaccurate sum. I always fix this by simply double clicking the cell, taking me into formula edit mode, and then hitting enter without actually modifying the contents of the cell. The sum immediately shows the proper total. The formula is very simple too, just additions and subtractions of values from different rows within the same column: =K3-K52-K91-K21
After that, i fix the other cells in the row by copying the value from the "fixed" cell and pasting into the other cells.
I was wondering if anyone has experienced the same thing, and/or might know how to prevent this from happening. It's really annoying.
Facebook
Twitter