If you allow ChatGPT to get into a negative loop (i.e. "I cannot do this") it will continue refusal of your requests. It refused to generate spreadsheets based on one prompt it could not fulfill, so I reset the thread and it was able to generate useful information again.