HI, I have a bit of a weird one! I have a spreadsheet with a lot of formulas in which is constantly updated based on the data saved in other spreadsheets. each week I have to save a static version of this report to create a snapshot view of that week/Month/YTD moment in time. I do this by copying the cells I want and then copy paste special (values and number formats) into a template which I then save and name for the relevant week. I then use the snapshot views to create a monthly report at the end of each month by creating a new spreadsheet that has sumproduct formulas in it which point to the relevant week's snapshot report. (sounds odd but it does make sense)!

My problem is this. in the monthly report that I create I have been getting VALUE errors in all of the cells that have the sumproduct formulas in them unless I go back into the snapshot report and change the delimiters on the cells containing the data to 'space'. I have no idea why this might be. can anyone shed any light on this and how to fix it otherwise I have to manually go into the snapshot report and do the delimiter thing with every column I am referencing in the monthly report.