Question description:
This user has given permission to use the problem statement for this
blog.
Hi, we like to upload our spreadsheets o(or extract them) nline and we were wondering if this was possible? How much memory can excel online take? does it tend to slow the laptop down? can formulas be used on excel online as well?
Solved by O. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
29/01/2018 - 11:57
Hello
Excelchat Expert
29/01/2018 - 11:58
please try to upload it here
User
29/01/2018 - 11:58
ok
Excelchat Expert
29/01/2018 - 11:58
ot to dropbox and share the link with me
User
29/01/2018 - 11:58
how do i upload
User
29/01/2018 - 11:58
ok will do
User
29/01/2018 - 12:02
https://edelmanftp.box.com/s/xph5tgh0f6sb03b3s185nbzyvx4weoek
User
29/01/2018 - 12:02
try this
Excelchat Expert
29/01/2018 - 12:04
downloading it
User
29/01/2018 - 12:05
ojk
User
29/01/2018 - 12:05
it takes a while
User
29/01/2018 - 12:05
so if you can let me know if it can be uploaded on excel online
Excelchat Expert
29/01/2018 - 12:06
opening now
User
29/01/2018 - 12:06
and if the information from each market countries (can be extracted to automatically create formulas)
User
29/01/2018 - 12:06
as we tend to do it manually
User
29/01/2018 - 12:06
which takes a LOT of time
Excelchat Expert
29/01/2018 - 12:07
ready
Excelchat Expert
29/01/2018 - 12:07
now please tell your requiremets
User
29/01/2018 - 12:08
how can we upload this doc online
User
29/01/2018 - 12:08
to excel online
User
29/01/2018 - 12:10
2) we usually input markets manually - is there a way we can have different tabs for each market and use them to create formulas for month by market
Excelchat Expert
29/01/2018 - 12:11
You can do next
Excelchat Expert
29/01/2018 - 12:11
to create separate excel files
Excelchat Expert
29/01/2018 - 12:11
for each
Excelchat Expert
29/01/2018 - 12:11
markets
Excelchat Expert
29/01/2018 - 12:11
then create 1 main excel file
Excelchat Expert
29/01/2018 - 12:12
and put a macro code in it
Excelchat Expert
29/01/2018 - 12:12
then press the button to consolidate all data in together
Excelchat Expert
29/01/2018 - 12:12
this is the best way
Excelchat Expert
29/01/2018 - 12:12
otherwise it will work slow even online
Excelchat Expert
29/01/2018 - 12:13
because each time it will recalculate everything..
User
29/01/2018 - 12:13
will pivot tables help?
Excelchat Expert
29/01/2018 - 12:13
No Pivot tables also load the file
Excelchat Expert
29/01/2018 - 12:13
really this is not a solution
User
29/01/2018 - 12:13
ok so where can i find more info in creating this
User
29/01/2018 - 12:13
like with the macro code
Excelchat Expert
29/01/2018 - 12:13
the best way
Excelchat Expert
29/01/2018 - 12:14
is VBA (Visual Basic Application) = Macro coding
Excelchat Expert
29/01/2018 - 12:14
yes
Excelchat Expert
29/01/2018 - 12:14
you can also to repost your question here
Excelchat Expert
29/01/2018 - 12:14
please mention the right type (VBA, but nor fixing formulas, other, pivot tables or etc.)
Excelchat Expert
29/01/2018 - 12:14
put VBA
Excelchat Expert
29/01/2018 - 12:15
and we (experts) will help you
Excelchat Expert
29/01/2018 - 12:15
or you can search in google and try to make it
Excelchat Expert
29/01/2018 - 12:15
u just need to separate this big file to markets
Excelchat Expert
29/01/2018 - 12:15
that's all
Excelchat Expert
29/01/2018 - 12:15
then consolidate using Macro
User
29/01/2018 - 12:15
ok got ya
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.