I have a spreadsheet that was created by a company I work for to bill for expenses. On one page, you input all your expenses and then the last page does a subtotal and total. This used to work fine. Now, the subtotal and total cells on the last page look fine onscreen (they have the correct figures) but in print preview and more importantly, when actually printing the document, those cells and any other cells that have an equation programmed have ########### in them. The subtotal on the first page (where the expenses are input) however prints fine. It's only on the last page that this happens.
I can't figure out what's going on. Like I said, this used to work before I upgraded Office (from X to 10.1.6). That's the only thing that I can think of that's changed. Also, I've tried the same document on 2 PCs and it looks and prints fine on them.
The ###### signs indicate that the column isn't wide enough to display the data contained in it. If you double-click the right boundary of the column it will expand the column to display the data that is contained within.
I am not sure if that is what you are talking about, but hopefully…
Thanks teeterboy, but that doesn't seem to be the problem.
The cell is easily 2x the size of the total, but i did try to resize it and it still shows #######. Also tried resizing the font. No luck.
The weird thing is too, that I went back and opened up 2 other invoices that I printed out fine in the past and now when I open them, the same thing happens. Onscreen, the correct totals show up fine but in print preview or when I actually print the invoice, ###### shows up in those cells.
I have this happening with Excel on occasion - the software seems to be a bit flaky in that respect.
In my cases, it always ended up being a problem with the width of the cell as teetherboy mentioned. Sometimes you could fix it by making the column wider or change the font, othertimes you needed to go in and reformat the cell parameters - they somehow changed from a number with two decimal places, which is what I normally use for currency, to something else.
I will also add that my boss was having a similar problem on the XP version too. Only on him it was giving those little green triangle warnings in the top left hand corner and an error about the format being switched from numbers to text or something… anyway it seems like there's some sort of bug in that respect.
Thanks duosonic, but I really don't think that it's a formatting or formula issue otherwise why would the exact same document on the exact same computer be perfectly fine on 11.2 and not on 10.1.6?
Plus, I didn't create the document. It was created by a company that I do some contract work for so I think technically I'm not supposed to monkeying around with the programming. Plus when I did take a look at the formula, it was way too hugely complicated!