Ask Your Question

A few questions, err:504, alternative is really slow, etc.

asked 2016-03-08 03:45:09 +0100

King_ZZ gravatar image

updated 2016-03-09 22:34:23 +0100

My main question...

I have tried to extract across documents with this code and I do not think it is possible as I get the error 504


If I have made an error or someone can think of a viable fix I would greatly appreciate it.

Or a better way of doing it maybe.

I have stripped them down a lot and I have added some notes on to help you with what I am trying to accomplish.

C:\fakepath\zTestSmall.ods C:\fakepath\zTestGlobal.ods

if it is not clear or you need additional help understanding what I want to do please ask

(* ---- --- --- ---- --- --- ---- --- --- ---- --- --- ---- --- **)

Not so important..

How do I copy code downwards (or across) as I have dragged a formula down 50,000 rows it took forever and it would be great if there was a fast way. (I know I can double click on the corner of a selected cell, but that doesn't help if you have not already got a column next to it already filled with data up to your desired stopping point).

(* ---- --- --- ---- --- --- ---- --- --- ---- --- --- ---- --- **)

This is a free program and the amount of work and effort that has gone into it is amazing, if you use this as much as I do or like what they have done you really should donate as this funds the progress and future of the project.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-03-10 00:06:21 +0100

m.a.riosv gravatar image

updated 2016-03-10 00:08:11 +0100

Not reference to the other file, when I think it's no necessary, avoid the issue with ROW() that doesn't work with external links.



Seems it works fine and not so slow.

In any case I think could be easy linking the whole data, and using a filter or a pivot table to treat them.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-03-08 03:45:09 +0100

Seen: 122 times

Last updated: Mar 10 '16