Linked Documents
Posted: Wed Oct 04, 2017 8:09 pm
I used OO calc to create a payroll. Each employee has a document of 12 spreadsheets - one for each month. These are all in a file for the year and there's an accumulation spreadsheet, which calculates the month's taxes - one for each month and at the end a page that has a calculation for each of the four tax quarters. I used the "special link" option to link fields from one sheet to another and wrote a line telling it to add together fields from all the appropriate docs. I started these in 2008. Whenever I open one of these documents, the question is posed: "This file contains links to other files, should they be updated?" I always click "yes" so that all files have updated calculations. I can't just click this once, as it asks this question repeatedly and I keep clicking "yes" to be sure no updates are missed. Recently it has been hanging up, saying OO is not responding, and I have to click yes many, many times. Also, it did not update correctly twice last year, causing me to have to file corrected 941's and again this year I just caught it - thankfully before I filed for the quarter and I can just pay the additional taxes first and then file. Any idea why this is getting so bogged down?