When I import data in to EViews from an Excel spreadsheet, by doing
Code: Select all
import foo.xlsx
My team's workflow involves a lot of back-and-forth between EViews and Excel, and the spreadsheet is quite large and takes a fair while to open, so this slows me down considerably.
Curiously, I have this problem using EViews 12, but my colleague uses a much earlier version (I think 8?) and doesn't have this problem at all - he can work a lot faster than me!
They are literally the same files: we both use OneDrive to share them. I get the same results even if it's spreadsheets he's never touched, and he has no problems on spreadsheets I've created. I've tried turning AutoSave on and off, and setting it off by default in Excel Options, with no difference.
Is there anything I can do here to reduce the amount of times I'm opening and closing the same spreadsheet in Excel?
I've found a couple of previous threads that touch on this which suggest the answer is no:
viewtopic.php?f=3&t=8721&start=15
viewtopic.php?f=3&t=1012&p=3565
Many thanks.