Heya,
I'm having an issue getting an array of cells that (the contents and range of which can change rapidly) from one work book to another and getting some quite strange results.
Firstly I tried to just copy over the entire thing but it seems that the two workbooks have different formats or something as one can only nest 7 IF functions, the other can, after looking at it one is a "Compatibility mode" the other is not, is there anyway around this, I don't want to risk copying and pasting the entire workbook into a new file as there are a lot of things embedded in there that I don't want to risk losing but if that's the only way I'm willing?
As the data required involves a lot of IF functions that are "overly nested" I tried other options. I tried the basic ='[Otherworkbook.xlsm]Sheet'!H4 etc, this mostly worked. On a few cells it would display different values to what was on the original sheet, I think it was just taking values from above it. I tried entering in the formula manually and it returned a different number, still not correct. I have no idea about this one, the original sheet involves some minor iteration that might be the problem but I'm stumped.
As I just needed to see the section of the other workbook I tried a picture link and leaving a note to change the print area (Or was going to look into a macro) but it seems as there is so much of the picture that is out of the print area it just isn't recognising it as being on the page and thus printing a blank page, despite it showing perfectly on the preview.
I don't mind if the picture is cut (So long as it's to the right size and can change automatically), the print size is changed or I manage to get a copy of the table cells into the other workbook, I just need something that shows the right data and I can print it out, as it stands if I just have the picture link showing the entire box it takes lots of time scaling and adjusting it so the array is anything more than a small spec on a page.
Any help on this is very much appreciated as I'm running out of ideas.
I'm having an issue getting an array of cells that (the contents and range of which can change rapidly) from one work book to another and getting some quite strange results.
Firstly I tried to just copy over the entire thing but it seems that the two workbooks have different formats or something as one can only nest 7 IF functions, the other can, after looking at it one is a "Compatibility mode" the other is not, is there anyway around this, I don't want to risk copying and pasting the entire workbook into a new file as there are a lot of things embedded in there that I don't want to risk losing but if that's the only way I'm willing?
As the data required involves a lot of IF functions that are "overly nested" I tried other options. I tried the basic ='[Otherworkbook.xlsm]Sheet'!H4 etc, this mostly worked. On a few cells it would display different values to what was on the original sheet, I think it was just taking values from above it. I tried entering in the formula manually and it returned a different number, still not correct. I have no idea about this one, the original sheet involves some minor iteration that might be the problem but I'm stumped.
As I just needed to see the section of the other workbook I tried a picture link and leaving a note to change the print area (Or was going to look into a macro) but it seems as there is so much of the picture that is out of the print area it just isn't recognising it as being on the page and thus printing a blank page, despite it showing perfectly on the preview.
I don't mind if the picture is cut (So long as it's to the right size and can change automatically), the print size is changed or I manage to get a copy of the table cells into the other workbook, I just need something that shows the right data and I can print it out, as it stands if I just have the picture link showing the entire box it takes lots of time scaling and adjusting it so the array is anything more than a small spec on a page.
Any help on this is very much appreciated as I'm running out of ideas.
