I'm hoping you can help me. I've been working on Spreadsheet, comprising of three workbooks, linked together, namely Summary, Income, Outgoings and almost finished setting it up.
However, after doing quite a lot of work in Outgoings, linked with Summary, I saved the workbook before closing. I've come back to it after a short while and it now won't open properly. Summary and Income work fine.
When I open the Outgoings Workbook, Excel opens the window but display is totally blank nd grey, like there is no document there. When I open Summary workbook too, then click on Outgoings, it just flicks back to Summary.
In File Explorer, Outgoings file shows as having 392 KB. Summary shows as having on 21 KB but has less calculations, as picks up the data from the other two sheets
Is there any way I can retrieve this file, please? I know I should have backed it up but I didn't :( I also know I should have been saving as I went along but I just got carried away :(
Many thanks for any help and advice. In the meantime, I'll start a new file :(
Thanks. I hadn't thought to try opening and amending/entering into another spreadsheet. ;) So, yes, I open two different spreadsheets (having copied them first ;) ) and they opened fine.
I'm thinking this issue could be to do with the links between different workbooks. So, I've made another copy of the Summary sheet, then opened the original Summary file. I'm now in the process of deleting all the links to the Outgoings workbook, to see if that makes a difference. Maybe I've got a link wrong, or something???