Must data exist locally to be worked on?

I have a usecase where I would like to use files too large to fit locally. Is this a supported use case?

Can you run ipfs where those files are? Or how are they accessible?

There is this: https://github.com/ipfs/ipfs-pack (might be outdated). The filestore and the urlstore features in go-ipfs might be relevant.