Hi
One of my work jobs requires me to copy last week's report (with 5 weeks data in them) and then alter it to put in the new week's data. Been doing this since I started and never had this issue before. What happens is I copy the file put in all the data to each sheet, then select all the sheets and print, then save and close down.
If I then reopen it it does open and shows the data but then it flickers a bit then all the data disappears but the tabs remain. By data disappearing I mean the whole white background with grid goes, and leaves blue background. One of the tabs data remains ok but the rest disappear.
This is really annoying and means I have to re run all my reports to make up the new report and fill in all the previous weeks and dates again rather than just move them back a week and put new week in.
I noticed something in my last report and that is all the tabs are still highlighted from the previous print job, and these seem to flash on and off before the data disappears. Could it be something to do with saving it and closing while all tabs are selected?
Tried running office diagnostics and it is ok.
Can't think why that should be a problem myself? any help would be much appreciated.
Thanks
G
One of my work jobs requires me to copy last week's report (with 5 weeks data in them) and then alter it to put in the new week's data. Been doing this since I started and never had this issue before. What happens is I copy the file put in all the data to each sheet, then select all the sheets and print, then save and close down.
If I then reopen it it does open and shows the data but then it flickers a bit then all the data disappears but the tabs remain. By data disappearing I mean the whole white background with grid goes, and leaves blue background. One of the tabs data remains ok but the rest disappear.
This is really annoying and means I have to re run all my reports to make up the new report and fill in all the previous weeks and dates again rather than just move them back a week and put new week in.
I noticed something in my last report and that is all the tabs are still highlighted from the previous print job, and these seem to flash on and off before the data disappears. Could it be something to do with saving it and closing while all tabs are selected?
Tried running office diagnostics and it is ok.
Can't think why that should be a problem myself? any help would be much appreciated.
Thanks
G