Max our Cross sheet references. Error message

This discussion was created from comments split from: Max out Cross sheet reference ?.

Answers

  • Roxanne
    Roxanne ✭✭✭

    Hi All I am having the same issue, however I cant add data together because I have an input sheet (Commissions) I then have to put it to another sheet and divide by 1000, in order to get the data in a format that doesnt look messy in a graph, in other words, the person inputting the sheet will put in 5499.52 - I then reference that field and divide it by 1000 to get 6. It is limiting me to a 100 only and I need a lot more than that, is there another solution?