Not sure anything can be done.
I have 2 books in sharepoint - bookA reads a lot of cells from bookB. 130.000 cells to be exact.
But it takes almost 5 minuts to open - is this just how it works, or is there someway I can work with this problem?
Not sure anything can be done.
I have 2 books in sharepoint - bookA reads a lot of cells from bookB. 130.000 cells to be exact.
But it takes almost 5 minuts to open - is this just how it works, or is there someway I can work with this problem?
When you say 'reads' do you mean the cells are linked. i.e. A1 in book A is something like
Formula:Please Login or Register to view this content.
A lot depends on what you need to do with all these cells. Does it help if you just copy the book B cells to book A and then work on them in BookA?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
So are you saying there are formulae in book A that are linked to cells in book B - like the example I gave earlier. I'm trying to understand what YOU mean by 'reads a lot of cells'
Assuming they are formula please tell us what they are.
My bad, sorry.
It just 130.000 cells with references to other workbooks as direct links =www.site.sharepoint.com/subsite/etc.A1 som that A1 is the same in both books.
It does this with 130.000 cells.
So yes, like ur example, just on a sharepoint site not C:
if you have 130 000 links to another file, that is what is causing the delay. Do you need all of those links to update, or are some, old links that wont change now (for instance, historical data)?
If so, consider changing as many of those as you can, to their values, to remove the formula (use copy/paste values)
Last edited by FDibbins; 01-09-2016 at 11:11 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Why not copy and paste values. It may still be slow but likely to be faster than linking all the cells.
Mmm.
You could have a macro do the copy and paste for you so that the owner of A doesn't need to manually open workbook B. But in any case how do you prevent A from opening B's workbook in read only mode?
If you really do need complete separation because there is stuff in B that mustn't be available to A why not have a common intermediate workbook that is available to both parties such that B outputs just the common data to the intermediate workbook?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks