Support Board
Date/Time: Fri, 01 Nov 2024 02:19:50 +0000
Post From: Spreadsheet Problem
| [2019-08-30 08:28:55] |
| user58907 - Posts: 83 |
|
I have managed to resolve this. When I created the spreadsheet, I worked through the chart tabs from L to R, numbering the sheets sequentially. On 28th I updated from v1941 to v1978 and in the process all formula source sheet numbers defaulted to the chart number, and an equivalent number of Sheet#s were created as formula source sheets. I've changed "Always Set Formula Source Sheet Number to Output Sheet Number" from Yes to No, and created the required formula source sheets. This has allowed me to delete the extraneous Sheet#s. |