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
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
RE: Multiple linked spreadsheets
Hi Amanda
There was a difference of nearly
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
