![]() |
To many empty cells
I am creating a website (yes with excel) but for example my data reaches
until row 75 on the first sheet. but in the browser (i saved it as a webpage) it goes to 400 rows! This is not a huge problem but we have slower computers in our business network and i think (even though the cells are empty) it even slows them down (just a tiny bit) when loading the page. My question is, how can i make sure the blank rows do not appear in the browser? PLease help. |
Can you tell me the version on MS Excel and at the same time the version of IE?
It works fine on IE 6.0. Other wise, what you can do is manually select all the blank rows that appear to be, at the end of the sheet. Then save the webpage and view it in explorer. If the problem persists, check for the versions as stated above. -- vijard "Hendrikkleine" wrote: I am creating a website (yes with excel) but for example my data reaches until row 75 on the first sheet. but in the browser (i saved it as a webpage) it goes to 400 rows! This is not a huge problem but we have slower computers in our business network and i think (even though the cells are empty) it even slows them down (just a tiny bit) when loading the page. My question is, how can i make sure the blank rows do not appear in the browser? PLease help. |
First, I don't create websites.
But if you hit ctrl-end in excel, does the cursor move to that same last cell that shows in your web page? If yes... Debra Dalgleish has some techniques to reset that last used cell if it's way past what you think it should be. http://www.contextures.com/xlfaqApp.html#Unused Hendrikkleine wrote: I am creating a website (yes with excel) but for example my data reaches until row 75 on the first sheet. but in the browser (i saved it as a webpage) it goes to 400 rows! This is not a huge problem but we have slower computers in our business network and i think (even though the cells are empty) it even slows them down (just a tiny bit) when loading the page. My question is, how can i make sure the blank rows do not appear in the browser? PLease help. -- Dave Peterson |
All times are GMT +1. The time now is 08:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com