The ExcelZone Compendium 2007


Please Login or Register to read the full article

The full article is available to registered members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.


Please login or register to join the discussion.

By Anonymous
01st Feb 2008 17:15

Importing csv data from a bank account into SAGE
Have tried to import csv data exported from an internet bank account into SAGE only to find that field headings do not match those that SAGE requires.
Any tips please?

Thanks (0)
08th Jul 2009 10:00

Excel: Links to other Excel workbooks
I've recently built a forecast spreadsheet using Period and YTD figures for each month. However, this is linked to another spreadsheet that's got just monthly forecast numbers. To enable me to do configure this, I've had to use the offset formula as every time I move across two columns on my YTD spreadsheet (Month/YTD; Month/YTD;....), it only needs to move across one cell on the monthly spreadsheet.
My problem starts when I close the backup spreadsheet where I'm picking up the monthly figures, as Excel then returns #VALUE errors in my YTD spreadsheet. When I try to evaluate the error, it specifies that the link is incorrect with #REF! When I replace the first month's figure with a simple formula refering it to the monthly spreadsheet it works fine, but if I copy this formula across then I'd have to manually change all the other monthly formulae - so this would defeat the purpose, especially if I have to role out the formula on all rows.

Any suggestions would be greatly appreciated
It doesn't rain but it pours

Thanks (0)