Hi there
I am having the a similar issue with the "Error 1004", when the report runs it opens 2 spreadsheets, one with the word 'test' on the tab name and no data, the other with the data from the report - some reports return the data formatted, some don't - I created the report and on my computer anyone can log in and run the report without this error. On other people's computers even if I log in the report runs with this error message. It would appear older existing reports created before I arrived are also creating this error message now!
I have been unable to find the reportdata xls file at this new school ('documents' folder cant be located at the moment!) but our help desk sent me their file to use, so whether this is the issue (a faulty reportdata.xls file, and I am the only one with the correct one on my machine!) or whether it is a 'microsoft office' issue I have no idea.
Asked my ICT guys to look into it but would love to hear if anyone else is having similar issues
Thanks guys