Oh dear. Sorry Patsy, it’s hard to know what to advise as I simply can’t
remember some of the older version of Excel, although they should fundamentally
be similar.
I can only suggest, as it sounds like that sort of problem, that if you are
running an older version/ un-updated of Windows (i.e. older than Windows 10) on
your main machine and the same version of Excel works on another machine it
could be about Windows updates. You might try, if you’ve not already done so,
checking for Windows updates on your main machine. More often than not it is
little issues like that which are resolved by keeping up to date. Mind you
keeping Windows up to date can also have the opposite effect too, and update
make older programmes become incompatible. (Money making industry – built in
obsolescence and all that.)
Tony
From: heraldnegindex-bounce@xxxxxxxxxxxxx <heraldnegindex-bounce@xxxxxxxxxxxxx>
on behalf of g.lunn800 <dmarc-noreply@xxxxxxxxxxxxx>
Date: Thursday, 4 November 2021 at 10:52
To: heraldnegindex@xxxxxxxxxxxxx <heraldnegindex@xxxxxxxxxxxxx>
Subject: [heraldnegindex] Re: Whoops - some missing entries!
Hello both,
Well, the problem seems to be with the computer rather than Excel because when
I swap to a different computer the problem goes away!!!
I have looked on line as you suggest, Tony, but I am able to copy the other
columns even the date progresses but what I have lost is the little Auto Infill
box which appears bottom right so I can select "Copy Cells" (as marked on snip).
All this work and worry and I could just work on another laptop but it's so old
I'm afraid of everything going off into the far distance.
...as for the 1955 pages, Chris. I have really only just made a start 1997 and
it will need to be added as a separate work sheet as you don't want me to send
in a repeat of what we have already done.
Thanks for your help.
Patsy
------ Original Message ------
From: "Tony Deadman" <tone747@xxxxxxxxxxx>
To: "heraldnegindex@xxxxxxxxxxxxx" <heraldnegindex@xxxxxxxxxxxxx>
Sent: Wednesday, 3 Nov, 2021 At 8:10 PM
Subject: [heraldnegindex] Re: Whoops - some missing entries!
Hard to know without seeing problem in action. There’s also this:
https://youtube.com/watch?v=FEGskAS7WuY&feature=share<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fyoutube.com%2Fwatch%3Fv%3DFEGskAS7WuY%26feature%3Dshare&data=04%7C01%7C%7C2af9628f3025479c533708d99f8139e8%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637716199638153577%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=3SbYI6cCpzLJ2Scx1GYSAvfaQ35APIu6fv1pFYIuL1w%3D&reserved=0>
Get Outlook for
iOS<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Faka.ms%2Fo0ukef&data=04%7C01%7C%7C2af9628f3025479c533708d99f8139e8%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637716199638163541%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=F5g87fal0S%2B5c4wTTk23%2BgtO40CdZcCKDk9Yu3ebL7I%3D&reserved=0>
________________________________
From: heraldnegindex-bounce@xxxxxxxxxxxxx <heraldnegindex-bounce@xxxxxxxxxxxxx>
on behalf of Chris Shepheard <chris.shepheard@xxxxxxxxxxxxxxx>
Sent: Wednesday, November 3, 2021 7:15:41 PM
To: heraldnegindex@xxxxxxxxxxxxx <heraldnegindex@xxxxxxxxxxxxx>
Subject: [heraldnegindex] Re: Whoops - some missing entries!
Well spotted Tony,
That’s not exactly where you’d think to look for something controlling the Auto
Fill!
Chris
Chris Shepheard
Chris.shepheard@xxxxxxxxxxxxxxx
From: heraldnegindex-bounce@xxxxxxxxxxxxx <heraldnegindex-bounce@xxxxxxxxxxxxx>
On Behalf Of Tony Deadman
Sent: 03 November 2021 19:01
To: heraldnegindex@xxxxxxxxxxxxx
Subject: [heraldnegindex] Re: Whoops - some missing entries!
Try this guide:
https://natechamberlain.com/2018/09/25/solution-excel-drag-to-fill-not-working-value-is-copied-formula-ignored/<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fnatechamberlain.com%2F2018%2F09%2F25%2Fsolution-excel-drag-to-fill-not-working-value-is-copied-formula-ignored%2F&data=04%7C01%7C%7C2af9628f3025479c533708d99f8139e8%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637716199638173492%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=edFe%2F%2FCRN9C1H0OQHiWEl%2FvSFth%2BfMOx9Ke5Aa4fILs%3D&reserved=0>
Get Outlook for
iOS<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Faka.ms%2Fo0ukef&data=04%7C01%7C%7C2af9628f3025479c533708d99f8139e8%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637716199638173492%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=syjq0gDDjWBXhN4wR8L6mIs5whxHWQms7X93WRPLso8%3D&reserved=0>
________________________________
From:
heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>
<heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>>
on behalf of Chris Shepheard
<chris.shepheard@xxxxxxxxxxxxxxx<mailto:chris.shepheard@xxxxxxxxxxxxxxx>>
Sent: Wednesday, November 3, 2021 6:02:27 PM
To: heraldnegindex@xxxxxxxxxxxxx<mailto:heraldnegindex@xxxxxxxxxxxxx>
<heraldnegindex@xxxxxxxxxxxxx<mailto:heraldnegindex@xxxxxxxxxxxxx>>
Subject: [heraldnegindex] Re: Whoops - some missing entries!
Patsy,
Is it still not there if you open a new Excel file/workbook?
If it is there that suggests that the file you are working on may have become
corrupted.
If not it might be worth running a “repair” on Excel.
That will differ on different versions of Excel and also Windows but take a
look in Control Panel under Programs and Features. Within that you may find
Excel or Microsoft Office and double clicking on that entry may offer the
option to repair the program.
Sorry I can’t be more specific but hopefully Tony will be able to guide you
further.
Chris
Chris Shepheard
Chris.shepheard@xxxxxxxxxxxxxxx<mailto:Chris.shepheard@xxxxxxxxxxxxxxx>
From:
heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>
<heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>>
On Behalf Of g.lunn800 ("g.lunn800")
Sent: 03 November 2021 17:17
To: heraldnegindex@xxxxxxxxxxxxx<mailto:heraldnegindex@xxxxxxxxxxxxx>
Subject: [heraldnegindex] Re: Whoops - some missing entries!
Hello Chris,
Thanks for this, but as I'm working on the old version of Excel - I can't see a
File Tab with any of the other bits you mention. Ah! just found it by right
clicking the Office tab. The "Enable Fill" is ticked so now I'm stuck. It just
means I have to enter every date rather than copying. It only enables the
following date but not to copy unless I have more than one to copy. It will
copy if I highlight two cells.
I hope this is clearer than the proverbial "mud".
Patsy
------ Original Message ------
From: "Chris Shepheard"
<chris.shepheard@xxxxxxxxxxxxxxx<mailto:chris.shepheard@xxxxxxxxxxxxxxx>>
To: heraldnegindex@xxxxxxxxxxxxx<mailto:heraldnegindex@xxxxxxxxxxxxx>
Sent: Tuesday, 2 Nov, 2021 At 5:09 PM
Subject: [heraldnegindex] Re: Whoops - some missing entries!
Hi Patsy,
If you’d like to tackle the missing months please let me know and I’ll send the
link – but no hurry.
With regard your missing AutoFill handle I suspect “Enable fill handle…” has
got turned off in Options (under Advanced in the Options dialog found under the
File tab at the top of the Excel sheet). Have a look and if it is unticked that
could be it – otherwise I don’t know what the answer is sorry.
Chris
Chris Shepheard
Chris.shepheard@xxxxxxxxxxxxxxx<mailto:Chris.shepheard@xxxxxxxxxxxxxxx>
From:
heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>
<heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>>
On Behalf Of g.lunn800 ("g.lunn800")
Sent: 02 November 2021 11:28
To: heraldnegindex@xxxxxxxxxxxxx<mailto:heraldnegindex@xxxxxxxxxxxxx>
Subject: [heraldnegindex] Re: Whoops - some missing entries!
Hello,
That would be ME!
1st January 1951 to 24th April 1955 we shared (Rosemary and I).
I have another problem someone may be able to help with.
I seem to have lost the little "fill" tab to be able to copy down or "copy
cells" off the date column. Can anyone help me get it back?
Patsy
------ Original Message ------
From: "Chris Shepheard"
<chris.shepheard@xxxxxxxxxxxxxxx<mailto:chris.shepheard@xxxxxxxxxxxxxxx>>
To: heraldnegindex@xxxxxxxxxxxxx<mailto:heraldnegindex@xxxxxxxxxxxxx>
Sent: Monday, 1 Nov, 2021 At 5:14 PM
Subject: [heraldnegindex] Re: Whoops - some missing entries!
Thanks Tony,
Your conclusions are the same as mine. We have the missing 1955 pages – just
needs a volunteer to take them on (who did the rest of 1955?)
Thanks for looking after the missing ones that Christine spotted, we can fit
them in in an “Odd” file when you manage to get hold of them.
They can also be added to the 1955 Excel sheet and/or dropped into the database
of the whole.
No hurry – we just need to make sure they aren’t overlooked.
Anybody fancy taking on the task of proof reading all the output! ☹ I think
that will be beyond us.
Chris
Chris Shepheard
Chris.shepheard@xxxxxxxxxxxxxxx<mailto:Chris.shepheard@xxxxxxxxxxxxxxx>
From:
heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>
<heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>>
On Behalf Of Tony Deadman
Sent: 01 November 2021 15:38
To: heraldnegindex@xxxxxxxxxxxxx<mailto:heraldnegindex@xxxxxxxxxxxxx>
Subject: [heraldnegindex] Re: Whoops - some missing entries!
Re missing pages:
1. Week 6 from 1996 is now hopefully resolved if Karen can read the scan
okay.
2. As Chris says, the last entry transcribed is in the volume 1st Jan 1951
to 22nd April 1955 (last negative 99999) then a gap until the start of 1956 –
which is included in the first part of the next volume which I copied apart
from the identified missing pages (as below):
3. Negatives 145 to 189 (boxes 4, 5 & 6) and negatives 460 to 504 (boxes 25,
26 & 27), which Christine’s now doing? are in the volume that starts from 23
April 1955 to Dec 1961 volume. I am sorry to say went back into the Museum. I
will ask Josh if I can borrow it again in order to copy them.
I think that’s correct.
Will let you know when I have those missing pages copied.
Tony
From:
heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>
<heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>>
on behalf of Chris Shepheard
<chris.shepheard@xxxxxxxxxxxxxxx<mailto:chris.shepheard@xxxxxxxxxxxxxxx>>
Date: Thursday, 28 October 2021 at 18:42
To: heraldnegindex@xxxxxxxxxxxxx<mailto:heraldnegindex@xxxxxxxxxxxxx>
<heraldnegindex@xxxxxxxxxxxxx<mailto:heraldnegindex@xxxxxxxxxxxxx>>
Subject: [heraldnegindex] Re: Whoops - some missing entries!
Thanks Tony,
Enjoy the break and hope the weather is reasonable.
No hurry for the scans.
Chris
Chris Shepheard
Chris.shepheard@xxxxxxxxxxxxxxx<mailto:Chris.shepheard@xxxxxxxxxxxxxxx>
From:
heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>
<heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>>
On Behalf Of Tony Deadman
Sent: 28 October 2021 18:37
To: heraldnegindex@xxxxxxxxxxxxx<mailto:heraldnegindex@xxxxxxxxxxxxx>
Subject: [heraldnegindex] Re: Whoops - some missing entries!
Am on ferry to Copenhagen at the moment. Also having all floors relaid on our
return next week but will try and sort out on return.
Toby🇩🇰😊
Get Outlook for
iOS<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Faka.ms%2Fo0ukef&data=04%7C01%7C%7C2af9628f3025479c533708d99f8139e8%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637716199638183446%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=56e2oKOhLxPJRrc00sj75918Bh3C9xmApekDcCEVDXY%3D&reserved=0>
________________________________
From:
heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>
<heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>>
on behalf of Chris Shepheard
<chris.shepheard@xxxxxxxxxxxxxxx<mailto:chris.shepheard@xxxxxxxxxxxxxxx>>
Sent: Thursday, October 28, 2021 5:57:13 PM
To: heraldnegindex@xxxxxxxxxxxxx<mailto:heraldnegindex@xxxxxxxxxxxxx>
<heraldnegindex@xxxxxxxxxxxxx<mailto:heraldnegindex@xxxxxxxxxxxxx>>
Subject: [heraldnegindex] Re: Whoops - some missing entries!
Hi Christine,
Not the same because in this case the missing items are in Tony’s scanned pages
but haven’t been transcribed. I think whoever did that multi-year volume
started at the beginning of 1956 and the 1955 pages which should have joined
the rest of 1955 from the previous volume were overlooked.
Basically there are just over 8 months that need transcribing still.
TONY – please can we try to get the missing numbers Christine has spotted below
plus the Week 6 of 1996 that Karen has just spotted re-photographed please? No
hurry but we mustn’t forget them – they can all be combined into one small file.
The transcribers’ output can then be called something like “Missing pages” and
can be added to the final database as one job (alternatively they can be added
to the relevant year’s Excel files but I suspect Josh will be keen to add them
all to the museum’s normal database system at some point).
Thanks,
Chris
Chris Shepheard
Chris.shepheard@xxxxxxxxxxxxxxx<mailto:Chris.shepheard@xxxxxxxxxxxxxxx>
From:
heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>
<heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>>
On Behalf Of Christine Callow
Sent: 27 October 2021 21:50
To: heraldnegindex@xxxxxxxxxxxxx<mailto:heraldnegindex@xxxxxxxxxxxxx>
Subject: [heraldnegindex] Re: Whoops - some missing entries!
Hi Chris - I messaged you a while back about the missing pages from 1955. They
are negatives numbered 145 to 189 (boxes 4, 5 & 6) and negatives 460 to 504
(boxes 25, 26 & 27)
Would this have something to do with it?
Christine
On Wed, 27 Oct 2021 at 19:25, Chris Shepheard
<chris.shepheard@xxxxxxxxxxxxxxx<mailto:chris.shepheard@xxxxxxxxxxxxxxx>> wrote:
Dear all,
While just searching for a photograph in the database I’ve just discovered over
half a year’s entries are missing.
I’m not quite sure why but the last entry that has been transcribed in 1955 is
on 22nd April – negative 9999 and there is then nothing until the start of 1956.
Does anybody fancy taking on filling the gap please?
It’s part of a volume that covers up until 1961 but the rest of it is already
there so it’s just negatives from 100 at the beginning of the file up to the
end of December that need doing.
If you can help please let me know and I’ll send you the volume link.
Thanks,
Chris
Chris Shepheard
Chris.shepheard@xxxxxxxxxxxxxxx<mailto:Chris.shepheard@xxxxxxxxxxxxxxx>
