This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a 7 sheet excel national d/base with the 4th sheet working out all the stats and therein lies the problem. Lots of links have been broken. Is there a person I can send it to?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Dear Keith
No files in the folder you shared.
Follow the instructions on the video and try again
Jeovany
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
Keith,
after you uploaded the file to your OneDrive, you have to create a public link and post the link here, otherwise we can not access / download your files. Instruction again (same link as Jeovany provided):
Share OneDrive files and folders - Office Support
Andreas.
Hello Jeovany
One of the main problems is when in the Counties & 1-sp stats sheet you add the BTO Code, say EB, in E1 (this code is got from the Species & Stats sheet and press return or Ctrl+shift+enter (clarify which please) the totals appear in columns D and E. However the figures in column D do not match the right counties, in this instance it should be one each for Northumberland, Essex, Avon, Cumbria, Pembrokeshire and Gloucestershire, where you can check the records in the pre 1950 sheet that should be. Column E works OK. Columns N, O and P also nee attention.
In adding records in the pre 1950 sheet I have just used insert row in the right place and entered the details. However, I think that some records have been archived, of which I have no knowledge, and it is these that I think are interfering with the results. I have been careful and used unused numbers in the Ref.No. column A. But, the links were all broken before this, three different Secretaries recently probably causing all the problems.
The Is it rare sheet is working OK and can you confirm that the Species & Stats sheet is to be entered manually or is it part of the process of regenerating fresh totals, etc.?
The Records sheet looks messy but appears to work OK!
Kind regards
Keith Naylor