Anybody knows why Grid only displays the first 100 rows. I have a grid with 267 rows in control panel, but when I pulled the grid in my templates, it only shows 100 rows. Does anybody knows why?
I don't have enough Grid data to test this BUT it sounds very much like you are running into the 100 record limit that EE adds automatically to channel entries if you don't specifiy a limit.
Try setting a high value for the limit="" parameter, like 500 or so and see if that fixes it. It could be that without that parameter EE limits it to 100 automatically.