Multiple linked spreadsheets

The UK's most regular instructor-led training courses.
Training information: excel training microsoft · Excel advanced · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Medium Priority · Version 2003

2 posts

ReplyFri 26 Jun 2009, 14:17Delegate Ellen said...

Ellen has attended:
Excel Advanced course
Excel Intermediate course

Multiple linked spreadsheets

I am getting large rounding differences on a couple of spreadsheets. These have linked sheets within a workbbook that is also linked to 2 maybe 3 other workbbooks. All data is correct but the totals are out. This seems to be rounding.

Any ideas?

Thanks

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Fri 19 Mar 2010	Bloomsbury	0	FULL
2003	Wed 24 Mar 2010	Limehouse	7		£212	£217
2007	Fri 26 Mar 2010	Rochester (Hoo)	0	FULL
2007	Mon 29 Mar 2010	Bloomsbury	3		£235	£240
2003	Wed 31 Mar 2010	Southwark	7		£219	£224
2007	Tue 6 Apr 2010	Limehouse	5		£235	£240
Full Schedule: See all 70 Excel Advanced course dates. Bookings currently available until 22nd December 2010.

2,024 posts

ReplyMon 29 Jun 2009, 13:37Trainer Amanda said...

RE: Multiple linked spreadsheets

Hello Ellen

Thank you for your question and welcome to the forum.

When you say 'large rounding differences', would you be able to provide some examples?

Kind regards
Amanda

2 posts

ReplyMon 29 Jun 2009, 13:46Delegate Ellen said...

RE: Multiple linked spreadsheets

Hi Amanda

There was a difference of nearly �200 across 2 workbooks, 1 of which had 13 sheets. 12 linked to the 13th which was linked to a seperate workbook. We had all these sheets and totals checked. They were fine in the 13 sheet but as soon as that was linked the figures changed?

Thanks

Ellen

2,024 posts

ReplyMon 29 Jun 2009, 14:19Trainer Amanda said...

RE: Multiple linked spreadsheets

Hi Ellen

Thanks for elaborating on your query.

Have you checked to see if the link is updating itself properly, so when you change a figure in the workbook with 13 sheets whilst the other file is closed, that the figure updates when you open the second workbook with the link?

Amanda

· How to Create Better Excel Spreadsheets: Part Three
· So Why Are There So Many File Types In Excel 2007?
· How to Create Better Excel Spreadsheets: Part Four
· Excel and Inventory Management
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business

Please browse our web site to find out more about
excel training microsoft and other Microsoft training courses.

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips