Hello every-one,
I'm having a problem with my jets.
When i have a very simple jet of 3MB and i delete all the tabs, then i still have a file of 2MB. The data is just some numbers and text. Is there anyone who knows what to do? All of my previous jets are growing to ngi and i don't know why …
kind regards,
Gert
Date
Votes
3 comments
-
Jet Reports Historic Posts When a file stays unusually big, there might be a cell way out of sight that contains some information (probably by accident).
You can find the last used cell with 'select special - last used cell'
I have had a file with only 100 lines that stayed 13MB, until I found a space entered by accident in line 1.048.576…
HTH
rmw -
Jet Reports Historic Posts If you are running Jet Reports and cancel the job before it finished the program will sometimes keep shadow copies of the report that you can delete. Be careful and ensure you have backups before you try this. If you open your report in Design mode and go into VBA (Alt + F11) you may note some additional sheets that don't show. If you click on them they will have the Visible status of VeryHidden. If you delete them while in design mode then it should reduce your size of your workbook if they exist.
Sometimes when using filters while copying and pasting data can result in thousands of unused lines. Open your workbook sheets and press CTRL+END. If this takes you to line 100,000+ then you have a lot of blank rows taking up space. Simply copy the needed data into a new work sheet and that will get rid of those unused rows.
Hope this helps. -
Jet Reports Historic Posts Hi,
have you tried to copy your code (just the cells with a code) to a new excelfile?
Is the jetfile still so big after running the new file?
regards
jetsetter
Please sign in to leave a comment.